Which of the following scenarios may lead to an irrecoverable error in a database system?
Asked in Mizoram PSC 4.Technical Paper-II
Answer under review: our editors are checking this question. Try the other MPSC Prelims previous year questions questions meanwhile.
More MPSC Prelims previous year questions questions
- Which one of the following is not a part of the ACID properties of database transactions?
- Which of the following statement is/are incorrect? A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable. B: Checkpoint in schedules are inserted to ensure recoverability.
- If the wait for graph contains a cycle :
- Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
- When transaction TS (T<sub>i</sub>) < TS (T<sub>j</sub>), then (T<sub>i</sub> older than T<sub>j</sub>) T<sub>i</sub> is allowed to wait; otherwise (T<sub>i</sub> younger than T<sub>j</sub>) abort T<sub>i</sub> (T<sub>i</sub> dies) and restart with a different timestamp (TS). This is
- Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
- The transaction log includes which of the following?
- Backward recovery is which of the following?