Category: 1z0-047 (v.4)

Exam 1z0-047: Oracle Database SQL Expert (update May 21th, 2016)

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

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?


Page 1 of 2812345...1020...Last »