Backup and Recovery Strategies MCQs

What is a database backup?

A) Copying the entire database once a week
B) Copying only the schema of the database
C) Copying the data from primary memory to secondary memory
D) Copying the database to protect against data loss
Answer: D
Which of the following is the primary reason for performing database backups?

A) To improve query performance
B) To reduce database size
C) To protect against data loss
D) To encrypt sensitive data
Answer: C
What is a full backup in the context of database backups?

A) Backing up only the schema of the database
B) Backing up only the indexes of the database
C) Backing up the entire database including all data and schema
D) Backing up the database periodically
Answer: C
Which backup type backs up only the data that has changed since the last full backup?

A) Full backup
B) Differential backup
C) Incremental backup
D) Copy backup
Answer: B
What is an incremental backup?

A) Backing up the entire database each time
B) Backing up only the data that has changed since the last full backup
C) Backing up only the schema of the database
D) Backing up only the indexes of the database
Answer: B
Which backup type copies all data every time it runs, regardless of whether it has changed since the last backup?

A) Full backup
B) Differential backup
C) Incremental backup
D) Copy backup
Answer: D
What is a differential backup?

A) Backing up only the data that has changed since the last full backup
B) Backing up the entire database each time
C) Backing up only the schema of the database
D) Backing up only the indexes of the database
Answer: A
Which backup type requires the least storage space but may take longer to restore?

A) Full backup
B) Differential backup
C) Incremental backup
D) Copy backup
Answer: C
What is a copy-only backup?

A) A backup that skips certain files
B) A backup that does not affect the backup chain
C) A backup that copies all files to a different location
D) A backup that includes only database indexes
Answer: B
Which backup strategy involves creating multiple copies of backups and storing them at different locations?

A) Incremental backup
B) Differential backup
C) Offsite backup
D) Copy backup
Answer: C
What is the purpose of offsite backups?

A) To reduce backup speed
B) To increase data redundancy
C) To reduce database size
D) To protect against site-wide disasters
Answer: D
Which of the following is a benefit of using offsite backups?

A) Increased backup speed
B) Decreased data redundancy
C) Protection against site-wide disasters
D) Reduced storage space
Answer: C
What is a backup retention policy?

A) A policy that specifies how often backups should be performed
B) A policy that specifies how long backups should be retained
C) A policy that specifies which files should be excluded from backups
D) A policy that specifies which backup type to use
Answer: B
Which of the following is a component of a backup and recovery plan?

A) Transaction log
B) Primary memory
C) Database schema
D) Database index
Answer: A
What is the purpose of a recovery point objective (RPO) in backup and recovery?

A) To define how quickly a system must be restored after a disaster
B) To define the maximum acceptable amount of data loss in case of a disaster
C) To define the order in which systems should be restored after a disaster
D) To define the frequency of backup operations
Answer: B
What does RPO stand for in the context of backup and recovery?

A) Recovery Plan Objective
B) Recovery Point Objective
C) Recovery Policy Objective
D) Recovery Process Objective
Answer: B
What is a recovery time objective (RTO) in backup and recovery?

A) The maximum acceptable amount of data loss in case of a disaster
B) The frequency of backup operations
C) The maximum amount of time allowed to restore a system after a disaster
D) The order in which systems should be restored after a disaster
Answer: C
What does RTO stand for in the context of backup and recovery?

A) Recovery Plan Objective
B) Recovery Point Objective
C) Recovery Time Objective
D) Recovery Process Objective
Answer: C
Which of the following is a key consideration when defining a backup strategy?

A) Data compression ratio
B) Network bandwidth
C) Data encryption algorithm
D) Backup and recovery costs
Answer: D
Which backup type is suitable for databases with large amounts of data that change infrequently?

A) Full backup
B) Differential backup
C) Incremental backup
D) Copy backup
Answer: A
What is an online backup?

A) A backup taken while the database is actively being used
B) A backup stored on an external hard drive
C) A backup taken offline
D) A backup that skips certain files
Answer: A
Which backup type is fastest to perform but requires the most storage space?

A) Full backup
B) Differential backup
C) Incremental backup
D) Copy backup
Answer: A
What is a hot backup?

A) A backup taken while the database is actively being used
B) A backup stored on an external hard drive
C) A backup taken offline
D) A backup that skips certain files
Answer: A
Which of the following is a disadvantage of using offline backups?