nerdexam
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

1Z0-071 question #111 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)
  • A
    11% (3)
  • B
    7% (2)
  • C
    78% (21)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice