Practice Test GeeksOracle SQL Practice Test
← All Oracle SQL Flashcard Decks

Oracle SQL DML Operations Flashcards

6 cards from real Oracle SQL practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Oracle SQL DML Operations flashcards as text

  1. What does ROLLBACK do in Oracle SQL?

    Answer: Undoes all uncommitted DML changes in the current transaction

    ROLLBACK undoes all uncommitted DML changes in the current transaction, restoring the database to its state at the last COMMIT.

  2. Which Oracle SQL feature allows you to set a named point within a transaction to partially roll back?

    Answer: SAVEPOINT

    SAVEPOINT marks a named point in a transaction so that ROLLBACK TO SAVEPOINT can undo changes made after that point without canceling the entire transaction.

  3. In Oracle SQL, what happens to uncommitted DML changes when a DDL statement is executed?

    Answer: They are committed automatically

    Oracle automatically issues an implicit COMMIT before and after every DDL statement, permanently saving any pending DML changes.

  4. Which Oracle SQL INSERT syntax inserts data into specific columns only?

    Answer: INSERT INTO table (col1, col2) VALUES (val1, val2)

    Listing column names in parentheses after the table name allows inserting values into specific columns; unspecified columns receive their default values or NULL.

  5. What does DELETE FROM employees WHERE department_id = 10 do in Oracle SQL?

    Answer: Removes all rows where department_id equals 10

    This DELETE statement removes only the rows in the employees table where department_id equals 10, leaving other rows intact.

  6. Which Oracle SQL multi-table INSERT directs rows to different tables based on conditions?

    Answer: INSERT ALL WHEN

    INSERT ALL with WHEN clauses conditionally inserts rows into different tables based on evaluated conditions, similar to a CASE statement.