Evaluate the following statement. Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

Question

Exhibit

Options

• AEach row is evaluated by the first WHEN clause and if the condition is false then the row would
• BAll rows are evaluated by all the three WHEN clauses.
• CEach row is evaluated by the first WHEN clause and if the condition is true, then the row would be
• DThe INSERT statement will return an error because the ELSE clause is missing.

• A
  8% (2)
• B
  85% (22)
• C
  4% (1)
• D
  4% (1)

No community discussion yet for this question.