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.