JNU PhD CS 2019
October 3, 2023GATE 2012
October 3, 2023Database-Management-System
|
Question 541
|
Which of the following is the recovery management technique in DDBMS ?
|
2PC (Two Phase Commit)
|
|
|
Backup
|
|
|
Immediate update
|
|
|
All of the above
|
Question 541 Explanation:
2PC (Two Phase Commit): The protocol achieves its goal even in many cases of temporary system failure (involving either process, network node, communication, etc. failures), and is thus widely used. It has commit-request phase (or voting phase) and commit phase.
→ Sometimes, power failures are happens backup and immediate update techniques help to recover.
→ Sometimes, power failures are happens backup and immediate update techniques help to recover.
Correct Answer: D
Question 541 Explanation:
2PC (Two Phase Commit): The protocol achieves its goal even in many cases of temporary system failure (involving either process, network node, communication, etc. failures), and is thus widely used. It has commit-request phase (or voting phase) and commit phase.
→ Sometimes, power failures are happens backup and immediate update techniques help to recover.
→ Sometimes, power failures are happens backup and immediate update techniques help to recover.