Oracle
1Z0-047 · Question #135
1Z0-047 Question #135: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #135. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. Evaluate the following MERGE statement: MERGE INTO orders_master o USING monthly_orders m ON (o.order_id = m.order_id) WHEN MATCHED THEN UPDATE SET o.order_total = m.order_total DELETE WHERE (m.order_total IS NULL) WHEN NOT MATCHED THEN INSERT VALUES (m.order_id, m.order_total); What would be the outcome of the above statement?
Exhibit
Options
- AThe ORDERS_MASTER table would contain the ORDER_IDs 1 and 2.
- BThe ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 3.
- CThe ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 4.
- DThe ORDERS_MASTER table would contain the ORDER_IDs 1, 2, 3 and 4.
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.