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?

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?

Accepted Answer

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

Answer

A. The ORDERS_MASTER table would contain the ORDER_IDs 1 and 2.

Answer

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

Answer

D. The ORDERS_MASTER table would contain the ORDER_IDs 1, 2, 3 and 4.

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 =…

Question

Exhibit

Options

How the community answered

Community Discussion