Practice Test GeeksSQL Practice Test
← All SQL Flashcard Decks

Transaction Control Language (TCL) Flashcards

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

Read the first 7 Transaction Control Language (TCL) flashcards as text

  1. Which property of a transaction ensures it completes fully or not at all?

    Answer: Atomicity

    Atomicity guarantees a transaction is all-or-nothing.

  2. In ACID, what does Durability guarantee?

    Answer: Committed changes survive system failures

    Durability ensures committed data persists even after crashes or power loss.

  3. Which TCL-related command sets the isolation level for a transaction in standard SQL?

    Answer: SET TRANSACTION

    SET TRANSACTION ISOLATION LEVEL configures how a transaction interacts with others.

  4. Which isolation level allows dirty reads?

    Answer: READ UNCOMMITTED

    READ UNCOMMITTED permits reading uncommitted changes from other transactions.

  5. A COMMIT inside a transaction with multiple savepoints does what to those savepoints?

    Answer: Removes all savepoints

    COMMIT ends the transaction, so all savepoints are released.

  6. Which event typically causes an implicit COMMIT in Oracle?

    Answer: Executing a DDL statement

    DDL statements like CREATE or ALTER trigger an implicit commit of the current transaction.

  7. What happens to row locks held by a transaction after COMMIT?

    Answer: They are released

    COMMIT releases locks acquired during the transaction.