View the exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS 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? 

Answer options:

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

B

References: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm