一、原题
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
![](https://img-blog.csdn.net/20140619130622015?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaG9sbHkyMDA4/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
Which MERGE statement is valid?
A.
MERGE INTO new_employees c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN MATCHED THEN
UPDATE SET name = e.first_name || ',' || e.last_name
WHEN NOT MATCHED THEN
INSERT value S
(e.employee_id,
e.first_name || ',
' || e.last_name);
B.
MERGE new_employees c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN EXISTS THEN UPDATE SET name = e.first_name ||
Which MERGE statement is valid?
A.
MERGE INTO new_employees c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN MATCHED THEN
UPDATE SET name = e.first_name || ',' || e.last_name
WHEN NOT MATCHED THEN
INSERT value S
(e.employee_id,
e.first_name || ',
' || e.last_name);
B.
MERGE new_employees c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN EXISTS THEN UPDATE SET name = e.first_name ||