gs gs116 Enterprise Data Management - Database Snapshots - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Enterprise Data Management. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 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
Question 2: Point out the correct statement.
Snapshots can be used in conjunction with database mirroring for reporting purposes
A snapshot is write-only, static view of a database
A snapshot is read-only, dynamic view of a database
None of the mentioned
Question 3: Which of the following scenario prefers not to use database snapshots?
Database Snapshots should be seen as high availability option
Database Snapshots should not be seen as an alternative to regular backups of your data
Snapshots can be created very quickly
All of the mentioned
Question 4: 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
Question 5: Point out the wrong statement.
You cannot used SQL Server Management Studio for creating a database snapshots
Snapshots have to be created using T-SQL
All recovery models support database snapshot
A database can have one and only one snapshot
Question 6: Which of the following code will throw error?
CREATE DATABASE AWDB_Snapshot_20080522 ON ( NAME = master, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AWDB_Snapshot.ss') AS SNAPSHOT OF master; CREATE DATABASE AWDB_Snapshot_2008 ON ( NAME = AdventureWorks_Data, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AWDB_Snapshot.ss') AS SNAPSHOT OF AdventureWorks; CREATE DATABASE AWDB_Snapshot_20080 ON ( NAME = AdventureWorks_Data, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AWDB_Snapshot.ss') AS SNAPSHOT OF AdventureWorks; CREATE DATABASE Snapshot_20080522 ON ( NAME = Adventure, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AWDB_Snapshot.ss') AS SNAPSHOT OF Adventure;
Question 7: To revert the database, which of the following Transact-SQL statement is used?
RESTORE Snapshot <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
RESTORE DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
REST DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
None of the mentioned
Question 8: Which of the following message comes when you try to update or delete the data snapshot?
Row Deletion
The row was committed
Row has been updated
Failed to update the database
Question 9: Syntax for creating database snapshot in SQL Server is _______________
DROP DATABASE [snapshottest];
DELETE DATABASE [snapshottest];
DROP Snapshot [snapshottest];
None of the mentioned
Question 10: What should be done to check to see if data still exists in the Snapshot?
Run Delete on Database Snapshot
Run Update on Database Snapshot
Run Select on Database Snapshot
Run Insert on Database Snapshot
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
