SQL Server Practice Test 6

1. To revert the database, which of the following Transact-SQL statement is used?

RESTORE DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

REST DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

None of the mentioned

RESTORE Snapshot <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

2. Point out the correct statement related to database maintenance.

Performing SQL Server Maintenance with No Maintenance Window

Performing SQL Server Maintenance with Scrip Maintenance Window

Performing SQL Server Maintenance with Maintenance Window

None of the mentioned

3. Which of the following command defragments clustered and secondary indexes of the specified table?

DBCC CHECKDB

DBCC SHOWCONTIG

DBCC CATALOG

DBCC INDEXDEFRAG

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

None of the mentioned

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

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'
    )

5. Which of the following tools is used for enterprise information management?

All of the mentioned

SSIS

SSAS

SSRS

6. Which of the following is used to Validate the database objects?

DBCC CATALOG

DBCC CHECKDB

DBCC SHOWCONTIG

None of the mentioned

7. Purpose of syspolicy_system_health_state in policy based management is ______________

Organize policies when you have many policies

Displays one row for each Policy-Based Management policy

None of the mentioned

Displays the time when policies were executed, the result of each execution, and details about errors if any occurred

8. How many ways are provided by SQL Server to copy a database?

9. Which of the following data tools comes installed with SQL Server 2012?

All of the mentioned

DQS

SSRS

SSAS

10. Purpose of DBCC DBREINDEX command is to ____________

All of the mentioned

Displays fragmentation information for the data and indexes of the specified table

Rebuilds only one index for a table in the specified database

Rebuilds one or more indexes for a table in the specified database