What is a database backup?
a) A copy of the database stored in a separate location for recovery purposes
b) A log of all transactions in the database
c) A snapshot of the database schema without the data
d) A security feature that encrypts the data in the database
Answer:
a) A copy of the database stored in a separate location for recovery purposes
Explanation:
A database backup is a copy of the database, including both its structure and data, stored in a separate location for recovery purposes in case of system failure, data corruption, or accidental deletion.
Backups are a critical part of database maintenance and disaster recovery strategies. Regular backups ensure that data can be restored to a point in time before the failure occurred.
Different types of backups include full backups, incremental backups, and differential backups, each offering varying levels of protection and speed of recovery.