The questions can come in any order, so make sure you are selecting right option for all questions.
1. __________ and __________ are the types of rollback technique.
(a) Full rollback (c) Partial rollback
2. Which factors will you consider while performing transaction recovery?
(e) All of the above
3. What are the different types of disk failures?
(a) Transaction failure (b) System failure (c) Disk failure
4. What are the types of recovery in transaction?
(a) deferred (b) immediate (c) after failure (d) during failure
5. Is taking backup of the data expensive?
(a) Yes
6. In what ways can you resolve a deadlock?
(d) All of the above
7. What are the parameters that are taken into consideration for choosing a victim to resolve the deadlock?
(a) Length of transaction of victim (younger transaction). (b) Number of transactions need to rollback by choosing some transactions as victims. (c) Ensuring minimum number of cascading rollback by choosing proper victim.
8. Identify the different stages in transaction recovery.
(a) Precondition (c) Condition (d) Post condition