Database Fundamentals — Question 27

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table.
At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?

Answer options

• A. The Customer table no longer exists.
• B. The Customer table is unaffected.
• C. The Customer table exists but has no data.
• D. The script fails.

Correct answer: A

Explanation

The correct answer is A because restoring the database from the 3:00 P.M. backup will revert all changes made after that time, including the creation of the Customer table. Therefore, the table that was created at 4:00 P.M. will not exist in the restored database. Options B and C are incorrect as they suggest the table remains or exists without data, which is not the case. Option D is also incorrect as the script will successfully execute, but the result will be the absence of the Customer table.