1z0-071 Oracle Database 12c SQL 第38题 MERGE statement

最新推荐文章于 2021-04-13 05:03:08 发布

城风漫漫

最新推荐文章于 2021-04-13 05:03:08 发布

阅读量1k

点赞数 1

分类专栏：数据库：Oracle DBA成长之路文章标签： 1z0-071 ocp oracle 11g oracle 12c

数据库：Oracle DBA成长之路专栏收录该内容

165 篇文章

订阅专栏

本文探讨了一个具体的MERGE语句案例，展示了如何通过MERGE操作更新ORDERS_MASTER表的数据。通过对两个表的数据对比和MERGE语句的执行，详细解释了匹配、更新及插入的具体过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Q38. View the exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.
ORDERS_MASTER
ORDER_TOTAL
ORDER_ID
1 1000
2 2000
3 3000
4
MONTHLY_ORDERS
ORDER_TOTAL
ORDER_ID
2 2500
3
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_MASTERtable would contain the ORDER_IDs1, 2, 3 and 4.
B. The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 4.
C. The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 3.
D. The ORDERS_MASTERtable would contain the ORDER_IDs1 and 2.

Correct Answer: B

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