Oracle
1Z0-071 · Question #111
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 correct answer is C. The statement will execute and a new row will be inserted in the SALES table. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AThe statement will fail because the subquery in the VALUES clause is not enclosed within single
- BThe statement will fail because a subquery cannot be used in a VALUES clause.
- CThe statement will execute and a new row will be inserted in the SALES table.
- DThe statement will fail because the VALUES clause is not required with the subquery.
How the community answered
(27 responses)- A11% (3)
- B7% (2)
- C78% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.
