Question

Oracle 12c

Regarding the INSERT statement, which of the following is correct?

		Non-numeric data is enclosed in single quotation marks.
		Column names are enclosed in parentheses ( ).
		The data values to be inserted are enclosed in parentheses ( ) after the VALUES keyword.
		all of the above

I answered "all of the above".

Answer 1

Insert into syntax is
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

So, valid answers are
Non-numeric data is enclosed in single quotation marks.
Column names are enclosed in parentheses ( ).
The data values to be inserted are enclosed in parentheses ( ) after the VALUES keyword.

$\color{blue}\underline{Answer:}$

all of the above