Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 7 of 50

Marks: +1, -0

View the Exhibit and examine the description for the SALES and CHANNELS tables. (Choose the best answer.)

You issued this SQL statement:

Which statement is true regarding the result?

The statement will fail because the subquery in the VALUES clause is not enclosed within single quotation marks.
The statement will fail because a subquery cannot be used in a VALUES clause.
The statement will execute and a new row will be inserted in the SALES table.
The statement will fail because the VALUES clause is not required with the subquery.

Go to Question:

Prev Question

Next Question