Category: 1z0-047 (v.2)

Exam 1z0-047: Oracle Database SQL Expert (November 6th 2014)

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 2612345...1020...Last »