Which of the following statements about the INSERT keyword is incorrect?
A) The keywords INSERT INTO are followed by the table name.
B) The VALUES clause identifies the data values that will be inserted into the table.
C) Oracle 12c does not allow column names to be omitted from the INSERT INTO clause.
D) If more than one column is listed,column names must be separated by commas.

Question

Which of the following statements about the INSERT keyword is incorrect?​
A) ​The keywords INSERT INTO are followed by the table name.
B) ​The VALUES clause identifies the data values that will be inserted into the table.
C) ​Oracle 12c does not allow column names to be omitted from the INSERT INTO clause.
D) ​If more than one column is listed,column names must be separated by commas.

Quizplus · Accepted Answer

This statement is incorrect. Oracle 12c allows column names to be omitted from the INSERT INTO clause, but in that case, values for all columns must be provided in the same order as the columns are defined in the table.

Which of the Following Statements About the INSERT Keyword Is