NSCT – Recovery Management MCQs 20 min Score: 0 Attempted: 0/20 Subscribe 1. . Recovery management in DBMS is used to: (A) Restore the database to a correct state after a failure (B) Compress tables (C) Encrypt tables (D) Delete old recordsShow All AnswersShow All Answers 2. . A database crash can occur due to: (A) Encryption errors (B) Data compression (C) Hardware failure, software failure, or power outage (D) Deletion of old recordsShow All Answers 3. . A transaction log is: (A) A compressed table (B) A backup file (C) A record of all database operations used for recovery (D) An encrypted keyShow All Answers 4. . Rollback recovery is used to: (A) Compress tables (B) Redo committed transactions (C) Encrypt data (D) Undo changes of uncommitted transactions after a crashShow All Answers 5. . Rollforward recovery is used to: (A) Undo uncommitted transactions (B) Redo committed transactions using logs after restoring from backup (C) Encrypt tables (D) Compress tablesShow All Answers 6. . Checkpointing in DBMS is: (A) Deleting old records (B) Compression of tables (C) Encryption of logs (D) A mechanism to save the current state of the database to reduce recovery timeShow All Answers 7. . Immediate database modification means: (A) Data is compressed (B) Changes are applied after commit only (C) Changes are applied to the database before the transaction commits (D) Data is encryptedShow All Answers 8. . Deferred database modification means: (A) Changes are applied to the database only after the transaction commits (B) Changes are applied immediately (C) Data is compressed (D) Data is encryptedShow All Answers 9. . Undo operation is used to: (A) Encrypt data (B) Redo committed transactions (C) Compress data (D) Reverse the effects of uncommitted transactionsShow All Answers 10. . Redo operation is used to: (A) Reapply changes of committed transactions (B) Undo uncommitted transactions (C) Compress tables (D) Encrypt logsShow All Answers 11. . Shadow paging is: (A) A recovery technique that maintains a shadow copy of the database pages (B) Encrypting pages (C) Compressing tables (D) Backup schedulingShow All Answers 12. . ARIES recovery algorithm stands for: (A) Algorithms for Recovery and Isolation Exploiting Semantics (B) Automatic Recovery in Encryption System (C) Advanced Redo Immediate Execution System (D) Atomic Recovery in Indexing SystemShow All Answers 13. . In ARIES, logging includes: (A) Encrypting logs (B) Compressing tables (C) Undo, redo, and redo-next operations (D) Deleting old filesShow All Answers 14. . Stable storage refers to: (A) Storage that survives system crashes (B) Compressed storage (C) Encrypted storage (D) Temporary storageShow All Answers 15. . Database backup can be: (A) Only full backup (B) Full backup, incremental backup, or differential backup (C) Only compressed backup (D) Only encrypted backupShow All Answers 16. . Full database backup means: (A) Compressing tables (B) Copying only changed data (C) Copying the entire database (D) Encrypting tablesShow All Answers 17. . Incremental backup means: (A) Compressing tables (B) Copying entire database (C) Copying only data modified since the last backup (D) Encrypting tablesShow All Answers 18. . Differential backup means: (A) Encrypting data (B) Copying only modified pages (C) Compressing data (D) Copying all changes made since the last full backupShow All Answers 19. . The purpose of recovery management is to: (A) Encrypt tables (B) Compress tables (C) Ensure database reliability and consistency after failures (D) Delete old data automaticallyShow All Answers 20. . The main goal of recovery management in DBMS is to: (A) Encrypt tables (B) Compress data (C) Restore committed data, undo uncommitted data, and maintain database integrity (D) Delete old recordsShow All Answers
