• Description: Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs
• Passing Score: 75%
• Practice Test - Number of questions: 839 questions
• Simulation Test - Number of questions: 839 questions
• Simulation Test Duration: 90 minutes
• Has explanations: Yes

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?

Answer(s)

1. MERGE INTO new_employees c USING employees e ON (c.employee_id =e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||','||e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id,e.first_name ||', '||e.last_name);
2. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id)WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||','|| e.last_name WHEN NOTMATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);
3. MERGE INTO new_employees c USING employees e ON (c.employee_id =e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||','||e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id,e.first_name ||', '||e.last_name);
4. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id)WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||','|| e.last_name WHENNOT MATCHED THEN INSERT INTO new_employees VALUES (e.employee_id,e.first_name ||', '||e.last_name);

MERGE INTO new_employees c USING employees e ON (c.employee_id =e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||','||e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id,e.first_name ||', '||e.last_name);