1Z0-071 Data Manipulation Language (DML) 2

Question 1

What is the purpose of a SAVEPOINT in Oracle transactions?

Accepted Answer

To mark an intermediate point in a transaction so a partial rollback is possible

Answer

To commit changes up to a specific point

Answer

To lock a table at a specific moment

Answer

To create a backup of the current data

Question 2

Which INSERT syntax copies rows from one table to another without using VALUES?

Accepted Answer

INSERT INTO target_table SELECT * FROM source_table

Answer

INSERT INTO target_table FROM source_table

Answer

INSERT SELECT * FROM source_table INTO target_table

Answer

COPY target_table FROM source_table

Question 3

What does an implicit COMMIT occur after in Oracle?

Accepted Answer

After DDL statements like CREATE and DROP

Answer

Every DML statement

Answer

After a ROLLBACK

Answer

After every SELECT statement

Question 4

Which statement about DELETE vs. TRUNCATE is TRUE in Oracle?

Accepted Answer

DELETE is DML and can be rolled back; TRUNCATE is DDL and cannot be rolled back

Answer

Both can be rolled back

Answer

DELETE is DDL; TRUNCATE is DML

Answer

TRUNCATE can be rolled back; DELETE cannot

Question 5

In a MERGE statement, what does the WHEN NOT MATCHED clause do?

Accepted Answer

Inserts source rows that have no matching row in the target

Answer

Updates existing rows in the target

Answer

Deletes rows that don't match

Answer

Rolls back the merge operation

Question 6

Which clause is mandatory in an UPDATE statement to avoid updating every row?

Accepted Answer

WHERE

Answer

SET

Answer

HAVING

Answer

RETURNING