Syntax for creating database snapshot in SQL Server is :
A. DROP DATABASE [snapshottest];
B. DELETE DATABASE [snapshottest];
C. DROP Snapshot [snapshottest];
D. None of the mentioned
Answer:A
Syntax for creating database snapshot in SQL Server is :
A. DROP DATABASE [snapshottest]; B. DELETE DATABASE [snapshottest]; C. DROP Snapshot [snapshottest]; D. None of the mentioned
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 ?