Oracle Exam 1Z0-071 Topic 3 Question 106 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 106
Topic #: 3

[All 1Z0-071 Questions]

Examine the data in the NEW_EMPLOYEES table:

Examine the data in the EMPLOYEES table:

You want to:

1. Update existing employee details in the EMPLOYEES table with data from the NEW EMPLOYEES

table.

2. Add new employee detail from the NEW_ EMPLOYEES able to the EMPLOYEES table.

Which statement will do this:

AMERGE INTO employees e
USING new employees ne
WHERE e.employee_id = ne.employee_ id
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job_id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name, ne.job_id,ne.salary) ;

BMERGE INTO employees e
USING new_employees n
ON (e.employee_id = ne.employee_id)
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name,ne.job_id,ne.salary);

CMERGE INTO employees e
USING new employees ne
ON (e.employee_id = ne.employee_id)
WHEN FOUND THEN
UPDATE SET e.name =ne.name, e.job_id=ne.job_id, e.salary =ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_id,ne.name,ne.job_id,ne.salary) ;

DMERGE INTO employees e
USING new_employees n
WHERE e.employee_id = ne.employee_id
WHEN FOUND THEN
UPDATE SET e.name=ne.name,e.job_id =ne.job_id, e.salary=ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_ id,ne.name,ne.job id,ne.salary) ;

Show Suggested Answer

Suggested Answer: B

by Lai at Sep 19, 2024, 04:02 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Bette

9 months ago

But A seems to be updating the existing employee details and adding new ones, which matches the requirement.

upvoted 0 times

...

Santos

9 months ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

9 months ago

I'm torn between A and B, but I think B might be the better choice. The USING clause seems clearer to me, and it's always good to be explicit about the join condition.

upvoted 0 times

Lavina

8 months ago

I see your point, B does seem clearer with the USING clause. It's always good to be explicit.

upvoted 0 times

...

Brent

8 months ago

I think B is the better option. The USING clause makes it easier to understand the join.

upvoted 0 times

...

Rosalyn

9 months ago

I agree, A seems like the right choice. It's important to be clear about the join condition.

upvoted 0 times

...

Tarra

9 months ago

A seems more accurate to me. The USING clause is more straightforward.

upvoted 0 times

...

Kristofer

9 months ago

Definitely option A. The MERGE statement is the perfect way to update existing records and insert new ones in a single operation. It's efficient and straightforward.

upvoted 0 times

Ilda

9 months ago

User 2

upvoted 0 times

...

Francesco

9 months ago

User 1

upvoted 0 times

...