Timedora
Free Practice Quiz Question List

Database Transactions and ACID Properties Online Quiz Questions

Use this free practice quiz with 20 questions to review Database Transactions and ACID Properties, test your knowledge, and prepare for your next test or exam.

20 questions
01
Choose one
1 point

A money transfer has reduced the source account balance, but the step that increases the destination account balance fails. What should the application do?

  1. A

    Commit the completed balance reduction, then retry the balance increase separately.

  2. B

    Roll back the transaction so neither balance change takes effect.

  3. C

    Commit the balance reduction and record the failed increase for later.

  4. D

    Keep the reduction and omit the increase.

02
Choose all
1 point

Select all statements that accurately describe the ACID properties of transactions.

  1. A

    Atomicity: all operations in a transaction take effect, or none do.

  2. B

    Atomicity: a successful commit guarantees recovery from every possible failure.

  3. C

    Consistency: committed changes preserve the database’s defined constraints and rules.

  4. D

    Isolation: concurrent transactions do not produce results that violate the chosen isolation guarantees.

  5. E

    Durability: a transaction always preserves all constraints, even before it commits.

  6. F

    Durability: after a successful commit, changes survive failures covered by the database’s durability mechanisms.

03
True or false
1 point

A successful commit makes changes durable against failures covered by the database’s durability mechanisms.

  1. A

    True

  2. B

    False

04
Written response
1 point

Which ACID property concerns concurrent transactions not producing results that violate the chosen isolation guarantees?

05
Fill in the blank
1 point

A transaction completes with or is undone with ROLLBACK.

06
Open ended
1 point

Explain how a transaction should handle a money transfer if one of its steps fails. Include why both balance changes belong together and what should be checked about the source account.

07
Choose one
1 point

A committed database change preserves the database’s defined constraints and rules. Which ACID property does this describe?

  1. A

    Atomicity

  2. B

    Isolation

  3. C

    Consistency

  4. D

    Durability

08
Choose all
1 point

A developer is implementing a money transfer. Select all practices supported for handling the transfer reliably.

  1. A

    Place the balance reduction and increase in the same transaction.

  2. B

    Commit the reduction even if the increase fails.

  3. C

    Roll back if a step fails rather than committing a partial transfer.

  4. D

    Treat a successful transaction as proof that the source account existed and had sufficient funds, without checking.

  5. E

    Check that the source account exists and has sufficient funds.

09
True or false
1 point

Exact transaction syntax and behavior are identical across all database systems.

  1. A

    True

  2. B

    False

10
Written response
1 point

What SQL command undoes a transaction instead of completing it with COMMIT?

11
Fill in the blank
1 point

A database transaction completes successfully with ; if it must be undone, use .

12
Choose one
1 point

A money transfer must either reduce one account's balance and increase the other's, or do neither. Which ACID property describes this all-or-nothing requirement?

  1. A

    Consistency

  2. B

    Atomicity

  3. C

    Isolation

  4. D

    Durability

13
Written response
1 point

Which ACID property means that either all operations in a transaction take effect or none do?

14
Choose one
1 point

A transaction has committed successfully. Which statement describes durability?

  1. A

    The transaction's operations are all-or-nothing.

  2. B

    Committed changes preserve database constraints.

  3. C

    Committed changes survive failures covered by the database's durability mechanisms.

  4. D

    Concurrent transactions meet the chosen isolation guarantees.

15
True or false
1 point

Isolation aims to prevent concurrent transactions from producing results that violate the chosen isolation guarantees.

  1. A

    True

  2. B

    False

16
Written response
1 point

Which ACID property concerns concurrent transactions not producing results that violate the chosen isolation guarantees?

17
Choose one
1 point

During a transfer, one step fails before both account balances have been updated. What should the application do to avoid committing a partial transfer?

  1. A

    Roll back the transaction rather than commit a partial transfer.

  2. B

    Commit the transaction so the completed step is saved.

  3. C

    Commit the debit and retry the credit later.

  4. D

    Treat the failure as unrelated to the transaction.

18
Choose one
1 point

Before carrying out a money transfer, which checks should the transaction make about the source account?

  1. A

    Check only that the destination account exists.

  2. B

    Check only that the source account exists.

  3. C

    Check only that the source account has sufficient funds.

  4. D

    Check that the source account exists and has sufficient funds.

19
Choose one
1 point

A money transfer reduces one account balance, but the step that increases the other balance fails. Which ACID property explains why the transaction should not leave only the reduction committed?

  1. A

    Consistency

  2. B

    Atomicity

  3. C

    Isolation

  4. D

    Durability

20
Choose one
1 point

A transaction commits a change while preserving the database’s defined constraints and rules. Which ACID property does this describe?

  1. A

    A committed change survives failures covered by the database’s durability mechanisms.

  2. B

    Concurrent transactions meet the chosen isolation guarantees.

  3. C

    Committed changes preserve the database’s defined constraints and rules.

  4. D

    All operations in a transaction take effect, or none do.