You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. You want to get yourself acquainted with
Database snapshots.
What T-SQL commands are used to create and remove database snapshots respectively?
Choose all that apply.
A.
UPDATE.
B.
CREATE SNAPSHOT
C.
DELETE SNAPSHOT
D.
DROP DATABASE
E.
REMOVE DATABASE
F.
DELETE DATABASE
G.
INSERT ANY DATASPACE.
H.
RECREATE.
I.
CREATE DATABASE
J.
REMOVE SNAPSHOT
K.
DROP SNAPSHOT
Explanation:
Microsoft SQL Server Database Administrators has a new feature with the Microsoft SQL Server
2005 Edition which is database snapshots.
A snapshot can persists until it is dropped using DROP DATABASE command.
Also multiple snapshots can be created with different names of a database called as source
database.
In order to create a MS SQL Server database snapshot, CREATE DATABASE statement is used.