1Z0-007 · Question #61
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…
The correct answer is A. MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id). The correct statement for MERGE is MERGE INTO table_name Incorrect answer: B Wrong statement with the keyword EXISTS C Wrong statement with the keyword EXISTS D Wrong statement on the MERGE new_employees
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)
- CMERGE INTO new_employees c USING employees e ON (c.employee_id =
- DMERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id)
How the community answered
(40 responses)- A73% (29)
- B8% (3)
- C5% (2)
- D15% (6)
Explanation
The correct statement for MERGE is MERGE INTO table_name Incorrect answer: B Wrong statement with the keyword EXISTS C Wrong statement with the keyword EXISTS D Wrong statement on the MERGE new_employees
Topics
Community Discussion
No community discussion yet for this question.