Explanation:A snapshot database always have an entry in sys.databases.source_database_id. 5. Point out the wrong statement :
A. You cannot used SQL Server Management Studio for creating a database snapshots
B. Snapshots have to be created using T-SQL
C. All recovery models support database snapshot
D. A database can have one and only one snapshot
Answer:A
Explanation:A snapshot database always have an entry in sys.databases.source_database_id. 5. Point out the wrong statement :
A. You cannot used SQL Server Management Studio for creating a database snapshots B. Snapshots have to be created using T-SQL C. All recovery models support database snapshot D. A database can have one and only one snapshot
Explanation:A database can have multiple snapshots. 6. Which of the following code will throw error ?