H-Hinge_1.3.2_transaction processing

A transaction in database context is

• a sequence of one or more SQL operations (like queries, updates) that are executed as a single, indivisible unit of work.

• a payment made for a purchase

• one withdrawal of money from ATM

• one deposit of cash into a bank account

What does the acronym ACID stand for in transaction processing?

• Atomicity, Clarity, Isolation, Durability

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Interoperability, Durability

What does the Atomicity property of ACID ensure?

• Transactions are executed sequentially.

• Transactions are either fully completed or not executed at all.

• All concurrent transactions produce identical results.

• Data integrity rules are never violated.

What is the purpose of record locking in a multi-user database?

• To allow multiple users to access a record simultaneously.

• To prevent simultaneous access to records during updates.

• To permanently restrict access to sensitive data.

• To prevent users from reading data in the database.

What is the potential problem arising from record locking?

• deadlock

• serialisation

• timestamp odering

• commitment ordering

How to solve the problem of deadlock? (tick all correct ones)

• deadlock

• serialisation

• timestamp odering

• commitment ordering