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





👇 More MCQs (Category-Wise) 👇

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Commerce MCQs

Graphic Design Softwares MCQs

General Knowledge (GK) MCQs

Class-wise MCQs

Others

Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.