ADVERTISEMENT
ADVERTISEMENT

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



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.