Which Of The Following Code Will Drop An Existing Snapshot #584
Which of the following code will DROP an existing snapshot before creating new?
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 Enterprise Data Management - Database Snapshots - Quiz No.1.
Which of the following code will DROP an existing snapshot before creating new?
IF NOT EXISTS( SELECT * FROM sys.databases WHERE name = 'DatabaseA_Snapshot' AND source_database_id IS NOT NULL ) BEGIN CREATE DATABASE [DatabaseA_Snapshot] ON (NAME=DatabaseA, FileName='<whatever>') AS SNAPSHOT OF [DatabaseA] END IF EXISTS( SELECT * FROM sys.databases WHERE name = 'DatabaseA_Snapshot' AND source_database_id IS NOT NULL ) BEGIN CREATE DATABASE [DatabaseA_Snapshot] ON (NAME=DatabaseA, FileName='<whatever>') AS SNAPSHOT OF [DatabaseA] END IF NOT EXISTS( SELECT * FROM system.databases WHERE name = 'DatabaseA_Snapshot' AND source_database_id IS NOT NULL ) BEGIN CREATE DATABASE [DatabaseA_Snapshot] ON (NAME=DatabaseA, FileName='<whatever>') AS SNAPSHOT OF [DatabaseA] END
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
