Oracle
1Z0-047 · Question #68
1Z0-047 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
Evaluate the following statement: INSERT ALL WHEN order_total < 10000 THEN INTO small_orders WHEN order_total > 10000 AND order_total < 20000 THEN INTO medium_orders WHEN order_total > 2000000 THEN INTO large_orders SELECT order_id, order_total, customer_id FROM orders; Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?
Options
- AThey are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any
- BThey are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated
- CThey are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated
- DThe INSERT statement would give an error because the ELSE clause is not present for support in case
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.