O
Which of the following is not phases of transaction?
O Redo Phase
Undo phase
Tranverse Phase
None of the given
Answers
Which of the following is not phases of transaction?
A - Redo Phase
B - Undo phase
C - Tranverse Phase
D - None of the given
Answer:
Traverse Phase is not a phase of a transaction in database management systems. Here option C is the correct answer.
Explanation:
Transactions are a fundamental part of database systems, which ensure data consistency and integrity. The process of transaction execution generally involves three phases, which are:
The Undo Phase: In this phase, the database system undoes all the changes made to the database by the transaction if it fails for some reason. This phase ensures the consistency of the database.
The Redo Phase: In this phase, the database system applies all the changes made by the transaction to the database if it executes successfully. This phase ensures the durability of the database.
The Commit Phase: In this phase, the transaction is permanently saved to the database, and all the changes made by the transaction are visible to other transactions.
The Traverse Phase is not a standard phase of transaction processing. It is possible that some specific database systems may have additional phases as per their design requirements, but in general, the above three phases are considered standard for transaction processing.
To know more about the concept please go through the links:
https://brainly.in/question/1919695
https://brainly.in/question/27319035
#SPJ1