Oracle
1Z0-061 · Question #222
1Z0-061 Question #222: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #222. The question stem and answer options stay visible for context.
Question
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which MERGE statement is valid?
Options
- AMERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id)
- BMERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN
- CMERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id)
- DMERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.