Question:
What happens when a transaction is rolled back?
What happens when a transaction is rolled back?
Show Hint
Rollback restores the database to its pre-transaction state (atomicity).
Updated On: Jul 2, 2026
- The transaction is committed
- The database remains unchanged
- The database crashes
- The transaction is re-executed automatically
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
Step 1: A rollback undoes all the changes a transaction made and restores the database to the state it had before the transaction started.
Step 2: This preserves atomicity: either all of a transaction's work is applied, or none of it is.
Step 3: Since every partial change is reversed, the net effect is that the database remains unchanged by that transaction.
Step 2: This preserves atomicity: either all of a transaction's work is applied, or none of it is.
Step 3: Since every partial change is reversed, the net effect is that the database remains unchanged by that transaction.
Was this answer helpful?
0
0
Top CPET Computer Science Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions
Top CPET DBMS - Transaction Schedules Questions
Top CPET Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions