OCP-1Z0-051 补充题库 第13题 MERGE INTO语句

一、原题

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:


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 ||