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 effect of issuing ROLLBACK TO SAVEPOINT sp1 in a transaction?
Answer: Undoes changes made after sp1 was set, but keeps sp1 and changes before it
ROLLBACK TO SAVEPOINT reverses DML changes made after the savepoint, preserving the savepoint and earlier changes.
Which DML statement is used to remove specific rows from a table?
Answer: DELETE
DELETE is the DML statement that removes specific rows matching the WHERE condition from a table.
When inserting a row, what value must you supply for a NOT NULL column with no DEFAULT?
Answer: A non-NULL explicit value must be provided
A column defined as NOT NULL with no DEFAULT requires an explicit non-NULL value in the INSERT statement.
Which keyword allows an INSERT statement to include a subquery instead of literal values?
Answer: SELECT replacing VALUES
Replacing the VALUES clause with a SELECT statement allows inserting multiple rows returned by the query.
What is the effect of a DDL statement on an active DML transaction in Oracle?
Answer: The DDL implicitly commits the pending transaction first
Oracle implicitly commits any pending DML transaction before executing a DDL statement.
Which MERGE clause handles the case where a source row already exists in the target table?
Answer: WHEN MATCHED THEN UPDATE
WHEN MATCHED THEN UPDATE specifies the action to take when the source row has a corresponding row in the target.