Which Of The Syntax Is Used For Creating Database Snapshot In #581
Which of the syntax is used for creating database snapshot in SQL Server?
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 syntax is used for creating database snapshot in SQL Server?
CREATE Snapshot database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' )
CREATE DATABASESNAPSHOT database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' )
CREATE DATABASE database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' )
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