Database Transactions Quiz

Which property of a transaction ensures that either all operations succeed or none do?

• Consistency

• Durability

• Atomicity

• Isolation

What happens if a transaction is not committed?

• All changes are saved permanently

• The transaction becomes read-only

• The changes are automatically backed up

• The changes are discarded if rolled back

Which of the following is a concurrency problem where one transaction overwrites another's updates?

• Dirty Read

• Phantom Read

• Lost Update

• Non-repeatable Read

What SQL keyword is used to manually start a transaction?

• BEGIN UPDATE

• COMMIT

• START TRANSACTION

• LOCK ROW

Which isolation level offers the least protection against concurrency issues?

• READ COMMITTED

• READ UNCOMMITTED

• SERIALIZABLE

• REPEATABLE READ

Transactions ensure that only one user can access a database at a time.

• True

• False

COMMIT saves all the changes made during a transaction.

• True

• False

Two-phase locking helps prevent concurrency problems.

• True

• False

The SERIALIZABLE isolation level allows phantom reads.

• True

• False

Using ROLLBACK can undo all operations in an uncommitted transaction.

• True

• False