What would be the outcome of the following MERGE statement?

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?

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?

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

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

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

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



Leave a Reply 3

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


user

user

create table om (i number, ii number );
create table om2 (i number, ii number );

select * from om;
select * from om2;

MERGE INTO om a
USING om2 b
ON (a.i = b.i)
WHEN MATCHED THEN
UPDATE SET a.ii = b.ii
DELETE WHERE (a.ii IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (b.i, b.ii);

user

user

insert into om values (2, 33333);

user

user

insert into om values (80, 820);