What would be the outcome of the above statement?

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?

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 and 2.

B.
The ORDERS_MASTER table would contain the ORDERJDs 1,2 and 3.

C.
The ORDERS_MASTER table would contain the ORDERJDs 1,2 and 4.

D.
The ORDERS MASTER table would contain the ORDER IDs 1,2,3 and 4.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Abdulali Aliyev

Abdulali Aliyev

C