Explanation:We drop the snapshot database like any other database using drop database command. 10.What should be done to check to see if data still exists in Snapshot ?
A. Run Delete on Database Snapshot
B. Run Update on Database Snapshot
C. Run Select on Database Snapshot
D. Run Insert on Database Snapshot
Answer:A
Explanation:We drop the snapshot database like any other database using drop database command. 10.What should be done to check to see if data still exists in Snapshot ?
A. Run Delete on Database Snapshot B. Run Update on Database Snapshot C. Run Select on Database Snapshot D. Run Insert on Database Snapshot
Explanation:You can run the same SELECT statement on the database snapshot. Here you can see that all of the data which we have deleted in the source database still exists. This is what we will recover using the database snapshot. Sanfoundry Global Education & Learning Series – SQL Server.