Advanced DML & Data Movement — Test 1

Correct Answer: D. Inserts new rows or updates existing rows in a single statement
Explanation: MERGE (upsert) uses WHEN MATCHED THEN UPDATE and WHEN NOT MATCHED THEN INSERT.

Correct Answer: A. INSERT ALL
Explanation: INSERT ALL INTO t1 ... INTO t2 ... SELECT ... is a multitable insert.

Correct Answer: C. WHEN MATCHED THEN UPDATE
Explanation: ON DUPLICATE KEY UPDATE is MySQL. Oracle uses WHEN MATCHED / WHEN NOT MATCHED.

Correct Answer: D. INSERT INTO t2 SELECT * FROM t1;
Explanation: INSERT ... SELECT inserts the query result into the target table.

Correct Answer: A. Creates a new table with the structure and data of the query
Explanation: This is called CTAS (Create Table As Select). Adding WHERE 1=0 copies only the structure.

Correct Answer: C. Data Pump (expdp/impdp)
Explanation: Data Pump exports and imports data and metadata. SQL*Loader loads data from external flat files.