The questions can come in any order, so make sure you are selecting right option for all questions.
1. What is the primary purpose of the "Committed" state in a database transaction?
(a) To indicate that the transaction has been successfully completed
2. Which ACID property ensures that once a transaction is committed, its effects are permanent and survive subsequent system failures?
(d) Durability
3. In the context of database transactions, what does the "Aborted" state signify?
(b) The transaction has been terminated due to an error
4. In the context of ACID properties, what does "Isolation" refer to?
(a) Ensuring transactions are independent and do not interfere with each other
5. If a database system adheres to the ACID properties, what does it mean when we say a transaction is "atomic"?
(a) The transaction is executed in a single, indivisible unit
6. Which state of a transaction implies that its changes have been permanently saved to the database, and it can no longer be rolled back?
(b) Committed
7. During which state of a transaction does it acquire all the necessary locks on the database objects it needs to access?
(a) Active
8. A transaction enters the failed state after the system determines that the transaction can no longer proceed with its normal execution (for example, because of hardware or logical errors). Such a transaction must be rolled back. Then, it,enters the aborted state. At this point, the system has which options
(c) restart or kill
9. In a typical database transaction lifecycle, which of the following is the correct sequence of states?
(a) Active, Committed, Aborted
10. The ACID property that ensures that a transaction brings the database from one valid state to another is called
(b) Consistency