View AnswerExplanation:CREATE DATABASE statement creates a new database and the files used to store the database, creates a database snapshot, or attaches a database from the detached files of a previously created database. 9. Syntax for dropping a database snapshot named “Sushant” would be :
A. DROP DATABASE Sushant
B. DROP DATABASE SNAP Sushant
C. DROP SNAPSHOT Sushant
D. None of the mentioned
Answer:A
View AnswerExplanation:CREATE DATABASE statement creates a new database and the files used to store the database, creates a database snapshot, or attaches a database from the detached files of a previously created database. 9. Syntax for dropping a database snapshot named “Sushant” would be :
A. DROP DATABASE Sushant B. DROP DATABASE SNAP Sushant C. DROP SNAPSHOT Sushant D. None of the mentioned
Explanation:DROP command removes database snapshot without affecting the source database. 10. View used used for displaying current status of database is :