ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

93 / 120

Question 93:

View the Exhibit and examine the description for the SALES and CHANNELS tables. (Choose the best answer.) 
image
You issued this SQL statement: 
image
Which statement is true regarding the result? 

Answer options:

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