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. Which Oracle SQL statement inserts multiple rows in a single operation using a subquery?

    Answer: INSERT INTO ... SELECT

    INSERT INTO ... SELECT inserts all rows returned by a SELECT query into the target table in a single DML operation.

  2. What does the MERGE statement do in Oracle SQL?

    Answer: Performs INSERT, UPDATE, or DELETE based on matching conditions in a single statement

    MERGE (also called UPSERT) conditionally inserts or updates rows based on whether a match exists between source and target tables.

  3. Which Oracle SQL statement removes ALL rows from a table without logging individual row deletions?

    Answer: TRUNCATE TABLE table

    TRUNCATE TABLE removes all rows without generating individual undo records, making it much faster than DELETE but non-transactional.

  4. In Oracle SQL, which DML statement modifies existing rows in a table?

    Answer: UPDATE

    The UPDATE statement modifies values in existing rows based on a WHERE condition, affecting all rows if WHERE is omitted.

  5. What does the RETURNING clause do in an Oracle SQL DML statement?

    Answer: Returns affected row values into a variable or bind variable

    The RETURNING clause captures column values from rows affected by INSERT, UPDATE, or DELETE into variables for use in PL/SQL.

  6. Which Oracle SQL statement permanently saves changes made by DML operations?

    Answer: COMMIT

    COMMIT makes all changes made since the last COMMIT or ROLLBACK permanent and visible to other sessions.