2024-25-1S-ICT106-BLISG3-SFQ11

Which of the following is NOT a primary goal of database backup and recovery?

• a) Protect data from loss
• b) Ensure data accuracy
• c) Recover data after a disaster
• d) Optimize database performance

What type of backup creates a full copy of the database at a specific point in time?

• a) Incremental backup
• b) Differential backup
• c) Full backup
• d) Transaction log backup

Which backup type only backs up data that has changed since the last full or differential backup?

• a) Incremental backup
• b) Differential backup
• c) Full backup
• d) Transaction log backup

What is the process of restoring a database to a previous consistent state after a failure?

• a) Backup
• b) Recovery
• c) Data integrity
• d) Normalization

Which of the following is NOT a common cause of data loss in a library database?

• a) Hardware failure
• b) Human error
• c) Natural disasters
• d) Database optimization

What is the term for ensuring that data is accurate, consistent, and reliable?

• a) Backup
• b) Recovery
• c) Data integrity
• d) Security

Which of the following is NOT a data integrity constraint in a library database?

• a) Primary key
• b) Foreign key
• c) Unique constraint
• d) Data type

What is the purpose of a primary key in a database table?

• a) To uniquely identify each record
• b) To establish relationships between tables
• c) To enforce data consistency
• d) To improve database performance

What is a foreign key in a database table?

• a) A field that references a primary key in another table
• b) A field that uniquely identifies each record
• c) A field that enforces data consistency
• d) A field that improves database performance

Which of the following is NOT a common data integrity issue in a library database?

• a) Duplicate records
• b) Missing data
• c) Inconsistent data
• d) Database optimization