Data Manipulation Language (DML) Flashcards
6 cards from real 1Z0-071 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Data Manipulation Language (DML) flashcards as text
What is the purpose of a SAVEPOINT in Oracle transactions?
Answer: To mark an intermediate point in a transaction so a partial rollback is possible
SAVEPOINT creates a named marker within a transaction, allowing ROLLBACK TO SAVEPOINT to undo only part of the transaction.
Which INSERT syntax copies rows from one table to another without using VALUES?
Answer: INSERT INTO target_table SELECT * FROM source_table
INSERT ... SELECT inserts rows returned by a SELECT statement directly into the target table.
What does an implicit COMMIT occur after in Oracle?
Answer: After DDL statements like CREATE and DROP
Oracle automatically issues an implicit COMMIT before and after every DDL statement.
Which statement about DELETE vs. TRUNCATE is TRUE in Oracle?
Answer: DELETE is DML and can be rolled back; TRUNCATE is DDL and cannot be rolled back
DELETE is a DML statement that can be rolled back; TRUNCATE is DDL that implicitly commits and cannot be rolled back.
In a MERGE statement, what does the WHEN NOT MATCHED clause do?
Answer: Inserts source rows that have no matching row in the target
WHEN NOT MATCHED triggers when the source row has no corresponding row in the target, allowing an INSERT action.
Which clause is mandatory in an UPDATE statement to avoid updating every row?
Answer: WHERE
Without a WHERE clause, UPDATE modifies every row in the table; WHERE restricts which rows are changed.