Home » MCQs » DBMS MCQs

DBMS Recovery with Concurrent Transaction MCQs

DBMS Recovery with Concurrent Transaction MCQs: This section contains multiple-choice questions and answers on Recovery with Concurrent Transaction in DBMS.
Submitted by Anushree Goswami, on April 21, 2022

1. When there is/are ___ transaction(s) being executed, the log files are interleaved.

1. One
2. Two
3. Three
4. Multiple

Answer: D) Multiple

Explanation:

When there are multiple transactions being executed, the log files are interleaved.

Discuss this Question

---

2. As ___ progresses, it becomes increasingly difficult for the ___ system to track all logs and then begin ___.

1. Storage
2. Recovery
3. Updation
4. Database

Answer: B) Recovery

Explanation:

As recovery progresses, it becomes increasingly difficult for the recovery system to track all logs and then begin recovery.

Discuss this Question

---

3. What is used to ease the recovery with concurrent transactions?

1. Points
2. Checks
3. Checkpoints
4. None

Answer: C) Checkpoints

Explanation:

To ease the recovery with concurrent transactions, checkpoints are used.

Discuss this Question

---

---