The questions can come in any order, so make sure you are selecting right option for all questions.
1. The transaction consists of all operations executed between the ________ and _________
(b) begin transaction and end transaction
2. A transaction is a unit of program execution that accesses and possibly updates various data items.
(a) TRUE
3. In the context of transactions, what does the WRITE(X) operation typically involve?
(a) Reading the current value of X and updating it in the transaction's temporary space
4. Select the ACID properties.
(a) Atomicity (c) Consistency (e) Isolation
5. Which operation is used to read the value of a data item X from the database?
(a) read(X)
6. In the example of transferring $50 from account A to account B, which ACID property is violated if the transaction fails after writing the deduction to A but before writing the addition to B?
(a) Atomicity
7. Which operation is used to write the value back to the database from a buffer?
(b) write(X)
8. What does the isolation property of transactions aim to prevent?
(c) Concurrent access issues
9. Which option is NOT one of the ACID properties of transactions?
(c) Invisibility
10. What are the possible states of a transaction?
(c) Active, partially committed, aborted, and committed.
11. What are the drawbacks of running transactions serially (one after the other)?
(b) Reduced database performance and throughput.
12. What is the primary purpose of the READ(X) operation in a database transaction?
(c) To transfer the data item X from the database to a variable, also called X, in a buffer in main memory belonging to the transaction that executed the read operation.
13. Which property ensures that all operations of a transaction are properly reflected in the database or none are?
(a) Atomicity
14. The purpose of the buffer in transaction processing is:
(b) To isolate the transaction's modifications from other transactions.
15. When might a transaction be aborted?
(b) When an error occurs during execution.