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?
A.
The ORDERS_MASTER table would contain the ORDERJDs 1,2 and 3.
B.
The ORDERS_MASTER table would contain the ORDERJDs 1,2 and 4.
C.
The ORDERS MASTER table would contain the ORDER IDs 1,2,3 and 4.
D.
The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.
Where’s the Exhibit? How should I know which ID’s would be contained in the table?
I got the exhibit from other site and its like this:
ORDERS_MASTER
order_id | order_total
1 | 1000
2 | 2000
3 | 3000
4 | null
MONTHLY_ORDERS
order_id | order_total
2 | 2500
3 | null