Home > Databases > Quizzes > RDBMS Basics Practice Test: Recovery System
RDBMS Basics Practice Test: Recovery System
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 88% • Most missed: “If a failure has occurred in the midst of a transfer, it is called as _________”
Quiz on failure classification and storage, recovery and atomicity. A database management system (DBMS) failure can be classified into three categories: Transaction failure: When a transaction cannot be executed or continues to fail Disk failure: When hardware errors affect the disk drive System failure: When an active transaction is terminated  Other types of failures include: Logical error, Network failure, Natural disasters, Carelessness, Sabotage, and Software errors.  Each type of failure requires different management. For example, system crashes are often caused by software bugs,... Show more
RDBMS Basics Practice Test: Recovery System
Time left 00:00
21 Questions

1. If there is a hardware malfunction or a bug in the database that causes the loss of content of volatile storage, it is called as ________
2. The partitions of the database into fixed length storage units are called as __________
3. The area of memory where blocks temporarily reside is called as ________
4. Which of the following fields does the update log record have?
5. If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
6. We say that a transaction has been ________ when its commit log record has been output to stable storage.
7. The most widely used structure for recording database modification is called as _______
8. Which of the following fields does the update log record have?
9. The value of the data item prior to the write is called as _________
10. The value of the data item prior to the write is called as _________
11. Which of the following is not a classification of storage
12. The unique identifier of the transaction that performed the write operation is called as _______
13. If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique
14. Which of the following is not a classification of storage
15. A __________ checkpoint is a checkpoint where transactions are allowed to perform updates even while buffer blocks are being written out.
16. If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________
17. If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________
18. If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
19. Which of the following can cause a transaction failure
20. The unique identifier of the transaction that performed the write operation is called as _______
21. If a failure has occurred in the midst of a transfer, it is called as _________

⚡ 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.