Examine the structure of the EMPLOYEES and NEW EMPLOYEES tables: Which MERGE statement is valid?

The correct answer is A. MERGE INTO new_employees c. Correct syntax for the MERGE command is MERGE INTO table1 USING table2 on (join_condition) WHEN MATCHED UPDATE SET col1 = value WHEN NOT MATCHED INSERT (column_list) values (column_values). Incorrect Answers B: WHEN EXIST THEN clause cannot be used in the MERGE statement. C…

Manipulating Data (DML)

Question

Examine the structure of the EMPLOYEES and NEW EMPLOYEES tables:

Which MERGE statement is valid?

Exhibit

Options

AMERGE INTO new_employees c
Bname = e.first_name ||','|| e.last_name
CMERGE new_employees c
Dname = e.first_name ||','|| e.last_name
EMERGE INTO new employees c
Fname = e.first_name ||','|| e.last_name
GMERGE new_employees c
Hname = e.first_name ||','|| e.last_name

How the community answered

(25 responses)

A
72% (18)
B
8% (2)
E
16% (4)
H
4% (1)

Explanation

Correct syntax for the MERGE command is MERGE INTO table1 USING table2 on (join_condition) WHEN MATCHED UPDATE SET col1 = value WHEN NOT MATCHED INSERT (column_list) values (column_values). Incorrect Answers B: WHEN EXIST THEN clause cannot be used in the MERGE statement. C: WHEN EXIST THEN clause cannot be used in the MERGE statement. D: FROM clause cannot be used in the MERGE statement.

Topics

#MERGE statement#MERGE INTO syntax#DML#table merge

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice