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?
When you restore a database using a backup created at 3:00 P.M., the database will return to the state it was in at that time. Since the Customer table was created at 4:00 P.M., which is after the backup was taken, it would not exist in the restored database. Therefore, the Customer table no longer exists after applying the backup.
the answer is A
Table was created after backup so it will not exist when restored
can the ans be explained ?
The attempt to create the customer table occurred after the backup. Therefore, when the backup is restored, it is as if no attempt had yet been made to create a customer table