View the Exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.Evaluate the following MERGE statement:

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.Evaluate the following MERGE statement:

Post by answerhappygod »

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_totalDELETE 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply