The following CREATE SQL statement are correct EXCEPT _____.a.CREATE TABLEb.CREATE SQLc.CREATE SCHEMAd.CREATE VIEW

Which SQL statement is used to create a new table in a database?Question 14Answera.CREATE TABLEb.NEW TABLEc.MAKE TABLEd.ADD TABLE

Syntax for creating views is __________a.DROP VIEW AS SELECTb.CREATE VIEW AS SELECTc.CREATE VIEW AS UPDATE

All NOT NULL columns from the base table must be included in the view in order for the INSERT query to function.Select one:a.FALSEb.TRUEc.All NULL columns from the base table must be included in the view in order for the INSERT query to function.d.None of the mentioned.

Which of the following are constraints that can be used with the create table command?Select one:a.references, alias, checkb.null, primary key, view ofc.primary key, not null, uniqued.primary key, default, between

Which of the following SQL statements will create a view named EMP_VIEW with an employee’s First name, last name, and ID, based on the EMPLOYEES tables?1 pointCREATE VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)AS SELECT EMP_ID, F_NAME, L_NAMEFROM EMPLOYEES; CREATE VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)FROM EMPLOYEES; CREATE VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)AS SELECT EMP_ID, F_NAME, L_NAME;NEW VIEW EMP_VIEW (EMP_ID, FIRSTNAME, LASTNAME)AS SELECT EMP_ID, F_NAME, L_NAMEFROM EMPLOYEES;