Home > Databases > Quizzes > DBMS Basics Practice Test: Recovery System
DBMS Basics Practice Test: Recovery System
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 50% • Most missed: “Non-volatile storage needs to have a _________ where the loses in future can be …”
Quiz on classification of failures, backup systems, buffer management and recovery and different lock releases. Database Management Systems (DBMS) use recovery techniques to recover data when the data's state changes or the entire data is lost. The two main types of recovery techniques are: Rollback/Undo Recovery: Undoes the effects of a transaction that failed due to a system error or failure Commit/Redo Recovery: Reapplies the changes made by a transaction that has been completed successfully to the database  Other recovery techniques include: Log-based recovery: Keeps a record of... Show more
DBMS Basics Practice Test: Recovery System
Time left 00:00
25 Questions

1. A special redo-only log record < Ti, Xj, V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called
2. The simplest way of transferring control is for the old primary to receive __________ from the old backup site.
3. An operation is said to be __________ if executing it several times in a row gives the same result as executing it once.
4. The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is
5. The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as
6. The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
7. Redo operations are performed exclusively using
8. The recovery scheme must also provide
9. If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.
10. What was the name of the first commercially available microprocessor chip?
11. ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.
12. If ___________ are not obtained in undo operation it will cause problem in undo-phase.
13. The ____________ scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
14. Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
15. ________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.
16. ____________ using a log record sets the data item specified in the log record to the old value.
17. Remote backup system must be _________ with the primary site.
18. The __________________ contains a list of blocks that have been updated in the database buffer.
19. ___________ determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
20. __________ starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.
21. In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
22. Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page.
23. The transaction can no longer continue with its normal execution because of some internal condition, such as bad input, data not found, overflow, or resource limit exceeded. This is
24. To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.
25. A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.