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?
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
- 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?
- From the following phases of software life cycle, which phase consumes the maximum effort?
- Which of the following Software life cycle model is suitable for products that are vulnerable to large number of risks?
- A module is said to have logical cohesion, if
- A module is said to be functionally independent of other modules when a module has