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.

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

If a temporary table contains custom fields not essential for joins with other tables, you should place these fields at the beginning of the CREATE TABLE statement.A.TrueB.False

Which of the following statements is wrong?Question 30Select one:a.SQL INSERT command is used to add data to a tableb.A data type of Char(30) indicates a fixed-length field of 30 charactersc.SQL was developed by IBM in the late 1970sd.While creating a table using SQL, specifying the NULL property for a column means that only null values can be stored in that column

Can we insert and delete rows into a View?Select one:a.Nob.Yesc.Rows of data can be inserted but can not deletedd.Rows of data can be deleted but cannot inserted.Clear my choice

What is the need for our query to execute successfully on an existing view?The specified table must contain data.We must have a SELECT privilege on the view.We should have a SELECT privilege only on the specified table.The specified table must be in the same database or schema.