By: Prof. Dr. Fazal Rehman | Last updated: September 23, 2024
Which type of backup captures all data and database objects at a specific point in time?
a) Incremental Backup
b) Differential Backup
c) Full Backup
d) Snapshot BackupAnswer: c) Full Backup
Which backup type saves only the changes made since the last full or incremental backup?
a) Differential Backup
b) Log Backup
c) Incremental Backup
d) Full BackupAnswer: a) Differential Backup
What is the main advantage of using incremental backups?
a) They provide a complete backup of all data
b) They are faster to perform and require less storage space than full backups
c) They allow for point-in-time recovery
d) They are easier to manage than full backupsAnswer: b) They are faster to perform and require less storage space than full backups
What is the primary disadvantage of incremental backups?
a) They require restoration of the last full backup and all subsequent incremental backups
b) They are slower to perform than full backups
c) They require more storage space than full backups
d) They are less secure than full backupsAnswer: a) They require restoration of the last full backup and all subsequent incremental backups
Which backup strategy involves creating copies of the database at regular intervals and using those for recovery?
a) Differential Backup
b) Incremental Backup
c) Snapshot Backup
d) Full BackupAnswer: c) Snapshot Backup
What is a primary feature of a differential backup?
a) It backs up all changes made since the last full backup
b) It backs up only changes made since the last incremental backup
c) It provides a snapshot of the database at a specific point in time
d) It requires restoration of the most recent full backup and the latest differential backupAnswer: d) It requires restoration of the most recent full backup and the latest differential backup
Which backup method involves capturing the database state and allowing rollback to that state without affecting the rest of the system?
a) Log Backup
b) Incremental Backup
c) Full Backup
d) Snapshot BackupAnswer: d) Snapshot Backup
In which scenario would a log backup be most useful?
a) When you need to restore the database to its state at the time of the last full backup
b) When you need to restore data to a specific point in time
c) When you want to reduce the size of backups
d) When you want to capture changes since the last snapshotAnswer: b) When you need to restore data to a specific point in time
What is the primary goal of a backup rotation strategy?
a) To ensure backups are performed at regular intervals
b) To manage and utilize backup media effectively over time
c) To compress backup data for faster recovery
d) To encrypt backup dataAnswer: b) To manage and utilize backup media effectively over time
Which backup strategy is characterized by periodic full backups and incremental backups taken between them?
a) Grandfather-Father-Son Backup
b) Tower of Hanoi Backup
c) Differential Backup
d) Snapshot BackupAnswer: a) Grandfather-Father-Son Backup
What does the “3-2-1 backup rule” involve?
a) Three types of backups, two copies of each, and one offsite backup
b) Three backup intervals, two backup methods, and one backup location
c) Three full backups, two incremental backups, and one differential backup
d) Three types of media, two backup methods, and one backup intervalAnswer: a) Three types of backups, two copies of each, and one offsite backup
Which backup type is typically used to protect against the risk of data loss due to hardware failures?
a) Full Backup
b) Differential Backup
c) Incremental Backup
d) Snapshot BackupAnswer: a) Full Backup
What is a primary benefit of using a backup strategy that includes offsite backups?
a) Faster recovery times
b) Enhanced backup performance
c) Protection against data loss due to site-specific disasters
d) Reduced backup storage requirementsAnswer: c) Protection against data loss due to site-specific disasters
Which backup type involves capturing only the changes since the last full backup?
a) Incremental Backup
b) Differential Backup
c) Log Backup
d) Snapshot BackupAnswer: b) Differential Backup
Which approach to backup involves capturing database changes and storing them in a way that allows the database to be restored to any point in time?
a) Log Backup
b) Full Backup
c) Snapshot Backup
d) Incremental BackupAnswer: a) Log Backup
