adplus-dvertising

Welcome to the Enterprise Data Management MCQs Page

Dive deep into the fascinating world of Enterprise Data Management with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Enterprise Data Management, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Enterprise Data Management, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

frame-decoration

Check out the MCQs below to embark on an enriching journey through Enterprise Data Management. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Enterprise Data Management. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Enterprise Data Management MCQs | Page 8 of 12

Explore more Topics under SQL Server

Q71.
Which of the syntax is used for creating database snapshot in SQL Server?

a.

CREATE Snapshot database_snapshot_name
ON
(
NAME = logical_file_name,
FILENAME = 'os_file_name'
)

b.

CREATE DATABASESNAPSHOT database_snapshot_name
ON
(
NAME = logical_file_name,
FILENAME = 'os_file_name'
)

c.

CREATE DATABASE database_snapshot_name
ON
(
NAME = logical_file_name,
FILENAME = 'os_file_name'
)

d.

None of the mentioned

Discuss
Answer: (c).CREATE DATABASE database_snapshot_name
ON
(
NAME = logical_file_name,
FILENAME = 'os_file_name'
)
Q72.
Point out the correct statement.

a.

Snapshots can be used in conjunction with database mirroring for reporting purposes

b.

A snapshot is write-only, static view of a database

c.

A snapshot is read-only, dynamic view of a database

d.

None of the mentioned

Discuss
Answer: (a).Snapshots can be used in conjunction with database mirroring for reporting purposes
Q73.
Which of the following scenario prefers not to use database snapshots?

a.

Database Snapshots should be seen as high availability option

b.

Database Snapshots should not be seen as an alternative to regular backups of your data

c.

Snapshots can be created very quickly

d.

All of the mentioned

Discuss
Answer: (b).Database Snapshots should not be seen as an alternative to regular backups of your data
Q74.
Which of the following code will DROP an existing snapshot before creating new?

a.

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

b.

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

c.

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

d.

None of the mentioned

Discuss
Answer: (a).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
Q75.
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

Discuss
Answer: (d).A database can have one and only one snapshot
Q76.
Which of the following code will throw error?

a.

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;

b.

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;

c.

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;

d.

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;

Discuss
Answer: (a).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;
Q77.
To revert the database, which of the following Transact-SQL statement is used?

a.

RESTORE Snapshot <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

b.

RESTORE DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

c.

REST DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

d.

None of the mentioned

Discuss
Answer: (b).RESTORE DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>
Q78.
Which of the following message comes when you try to update or delete the data snapshot?

a.

Row Deletion

b.

The row was committed

c.

Row has been updated

d.

Failed to update the database

Discuss
Answer: (c).Row has been updated
Q79.
Syntax for creating database snapshot in SQL Server is _______________

a.

DROP DATABASE [snapshottest];

b.

DELETE DATABASE [snapshottest];

c.

DROP Snapshot [snapshottest];

d.

None of the mentioned

Discuss
Answer: (a).DROP DATABASE [snapshottest];
Q80.
What should be done to check to see if data still exists in the Snapshot?

a.

Run Delete on Database Snapshot

b.

Run Update on Database Snapshot

c.

Run Select on Database Snapshot

d.

Run Insert on Database Snapshot

Discuss
Answer: (c).Run Select on Database Snapshot
Page 8 of 12

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...