Adbase Quiz3

What is a transaction in a database?

• A single SQL statement in an application program

• A table in the database

• A request to update the database

• A collection of operations forming a logical unit of work

Which property of transactions ensures that all operations of a transaction should be completed?

• Durability

• Isolation

• Atomicity

• Consistency

What is the purpose of a transaction log in a DBMS?

• To optimize query performance

• To manage user access to the database

• To store the database schema

• To track all the transactions that update the database

What is the main problem addressed by concurrency control techniques in a database?

• Uncommitted data

• Inconsistent retrievals

• Lost Update

• All of the above

Which isolation level in a database prevents other transactions from modifying or deleting data read by the current transaction?

• REPEATABLE READ

• READ COMMITTED

• SERIALIZABLE

• READ UNCOMMITTED