Recovery techniques (log-based, shadow paging) MCQs in DBMS

By: Prof. Dr. Fazal Rehman Shamil | Last updated: September 23, 2024

1. What is the primary purpose of log-based recovery techniques in DBMS?
   a) To improve query performance
   b) To ensure data integrity by recording changes and enabling recovery
   c) To reduce the size of the database
   d) To manage user access controlAnswer: b) To ensure data integrity by recording changes and enabling recovery
2. Which recovery technique involves maintaining a log of all operations performed on the database to enable rollbacks and recoveries?
   a) Shadow Paging
   b) Log-based Recovery
   c) Checkpointing
   d) SnapshotsAnswer: b) Log-based Recovery
3. In log-based recovery, what is the primary function of the ‘redo’ log?
   a) To undo changes made by a transaction
   b) To record changes made by committed transactions
   c) To capture the initial state of the database
   d) To save the database schemaAnswer: b) To record changes made by committed transactions
4. Which log-based recovery technique records all changes made by transactions in a sequential log file?
   a) Write-Ahead Logging (WAL)
   b) Shadow Paging
   c) Deferred Update
   d) Immediate UpdateAnswer: a) Write-Ahead Logging (WAL)
5. In which recovery technique are changes applied directly to the database and logged simultaneously?
   a) Shadow Paging
   b) Deferred Update
   c) Immediate Update
   d) Undo LoggingAnswer: c) Immediate Update
6. What is the main advantage of shadow paging over log-based recovery?
   a) It requires less storage space for backup
   b) It allows for more efficient recovery without logging all operations
   c) It is simpler to implement compared to log-based recovery
   d) It provides point-in-time recoveryAnswer: b) It allows for more efficient recovery without logging all operations
7. In shadow paging, what is the role of the ‘shadow page’?
   a) To record all changes made to the database
   b) To store the previous state of the database for recovery purposes
   c) To maintain a record of committed transactions
   d) To handle the undo operationsAnswer: b) To store the previous state of the database for recovery purposes
8. Which recovery technique involves maintaining two page tables, where the shadow page table holds the original state and the current page table holds the latest state?
   a) Write-Ahead Logging (WAL)
   b) Shadow Paging
   c) Deferred Update
   d) Log-Based RecoveryAnswer: b) Shadow Paging
9. What is the primary disadvantage of shadow paging compared to log-based recovery?
   a) Higher complexity in recovery operations
   b) Increased disk space requirements
   c) Slower recovery time
   d) Reduced flexibility in recovery optionsAnswer: b) Increased disk space requirements
10. In log-based recovery, what does the term ‘checkpoint’ refer to?
    a) A process of creating a backup of the database
    b) A point where the state of the database is recorded to facilitate faster recovery
    c) A method for validating transactions
    d) A process of logging all transactions for recoveryAnswer: b) A point where the state of the database is recorded to facilitate faster recovery
11. Which recovery method involves deferring the updates of a transaction until it has been committed?
    a) Immediate Update
    b) Deferred Update
    c) Write-Ahead Logging
    d) Shadow PagingAnswer: b) Deferred Update
12. What is the main benefit of using deferred update in transaction recovery?
    a) Immediate application of changes to the database
    b) Reduced logging overhead
    c) Ability to roll back transactions without affecting the database
    d) Improved performance in high-concurrency environmentsAnswer: c) Ability to roll back transactions without affecting the database
13. In which recovery method are all changes written to the log before they are applied to the database?
    a) Shadow Paging
    b) Write-Ahead Logging
    c) Deferred Update
    d) Immediate UpdateAnswer: b) Write-Ahead Logging
14. How does shadow paging handle a transaction rollback?
    a) By restoring the database from the shadow page table
    b) By applying undo logs from the transaction log
    c) By reloading the last full backup
    d) By using deferred updatesAnswer: a) By restoring the database from the shadow page table
15. Which recovery technique typically requires the database to be in a consistent state before the recovery process can start?
    a) Log-Based Recovery
    b) Shadow Paging
    c) Checkpointing
    d) Deferred UpdateAnswer: c) Checkpointing

 

More MCQs Of Database Systems

1. Database Models MCQs in DBMS
   1. Hierarchical model MCQs in DBMS
   2. Network model MCQs in DBMS
   3. Relational model MCQs in DBMS
   4. Object-oriented model MCQs in DBMS
   5. NoSQL databases MCQs in DBMS
2. Relational Database Model MCQs in DBMS
   1. tables, attributes, tuples, and relations MCQs in DBMS
   2. Primary keys and foreign keys MCQs in DBMS
   3. Integrity constraints MCQs in DBMS
3. SQL (Structured Query Language) MCQs in DBMS
   1. Data Definition Language (DDL) MCQs in DBMS
   2. Data Manipulation Language (DML) MCQs in DBMS
   3. Data Control Language (DCL) MCQs in DBMS
   4. Transaction Control Language (TCL) MCQs in DBMS
   5. Advanced SQL queries and functions MCQs in DBMS
4. Database Design MCQs in DBMS
   1. Entity-Relationship (ER) modeling MCQs in DBMS
   2. Extended ER modeling MCQs in DBMS
   3. Normalization and normal forms (1NF, 2NF, 3NF, BCNF) MCQs in DBMS
   4. Denormalization MCQs in DBMS
5. Database Management System Architecture MCQs in DBMS
   1. Three-schema architecture (external, conceptual, internal) MCQs in DBMS
   2. Data independence MCQs in DBMS
   3. DBMS components and functions MCQs in DBMS
6. Storage and File Structure MCQs in DBMS
   1. Data storage on physical media MCQs in DBMS
   2. File organization and access methods MCQs
   3. Indexing (B-trees, hash indexing) MCQs in DBMS
   4. RAID technology MCQs in DBMS
7. Query Processing and Optimization MCQs in DBMS
8. Database Transaction Management MCQs in DBMS
   1. ACID properties (Atomicity, Consistency, Isolation, Durability) MCQs in DBMS
   2. Transaction states and lifecycle MCQs in DBMS
   3. Concurrency control techniques (locking, timestamping, multiversion) MCQs in DBMS
   4. Deadlock detection and resolution MCQs in DBMS
9. Database Security and Authorization MCQs in DBMS
   1. Authentication and authorization mechanisms MCQs in DBMS
   2. Data encryption techniques MCQs in DBMS
   3. Role-based access control MCQs in DBMS
   4. SQL injection prevention MCQs in DBMS
10. Backup and Recovery MCQs in DBMS
    1. Backup types and strategies MCQs in DBMS
    2. Recovery techniques (log-based, shadow paging) MCQs in DBMS
    3. Disaster recovery planning MCQs in DBMS
11. Distributed Databases MCQs in DBMS
    1. Distributed database architecture MCQs MCQs in DBMS
    2. Data fragmentation, replication, and allocation in DBMS
    3. Distributed query processing MCQs in DBMS
    4. Consistency models and protocols MCQs in DBMS

1. SET 1: database design mcqs (database design mcqs )
2. SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
3. SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
4. SET 4: database systems mcqs (database systems mcqs)
5. SET 5: dbms mcqs (dbms mcqs )
6. SET 6: dbms mcqs with answers (dbms mcqs with answers)
7. SET 7: solved mcqs of dbms (solved mcqs of dbms)
8. SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
9. SET 9: relational database management system mcqs(relational database management system mcqs)
10. SET 10: solved mcqs of database management system(solved mcqs of database management system)
11. SET 11: basic database mcqs pdf (basic database mcqs pdf)
12. SET 12: relational database management system mcqs (relational database management system mcqs )
13. SET 13: database mcqs online test (database mcqs online test)
14. SET 14: database interview questions mcqs (database interview questions mcqs)
15. SET 15: database developer mcqs (database developer mcqs)
16. SET 16: database Repeated mcqs (database Repeated mcqs)
17. SET 17: Database mcqs PPSC (Database mcqs PPSC)
18. SET 18: Database mcqs FPSC (Database mcqs FPSC)
19. SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)

New Arrival

Database interview questions