Database Fundamentals — Question 28

In which situation do you need to perform a restore on a database?

Answer options

• A. when data becomes corrupted in the database
• B. when you need to roll back a transaction
• C. when you encounter an error in your application
• D. when data needs to be deleted from the database

Correct answer: A

Explanation

A restore is required when the data in the database is corrupted, allowing you to revert to a previous, uncorrupted state. The other options describe actions that do not necessitate a full database restore; for instance, rolling back a transaction or handling application errors do not require restoring the entire database.