Oracle

1Z0-061 · Question #90

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. This is the correct MERGE statement syntax

Manipulating Data

Question

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which MERGE statement is valid?

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 cUSING employees e
Fname = e.first_name ||', '|| e.last_name
GMERGE new_employees c
Hname = e.first_name ||', '|| e.last_name

How the community answered

(60 responses)

A
72% (43)
B
7% (4)
D
2% (1)
E
2% (1)
F
3% (2)
H
15% (9)

Explanation

This is the correct MERGE statement syntax

Topics

#MERGE statement#DML#conditional insert update#table join

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-061 Practice