SQL Server Mock Test 6

10%

Question 1 of 10

1. 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

Question 1 of 10

Question 2 of 10

2. How many types of backups are provided by SQL Server?

Question 2 of 10

Question 3 of 10

3. 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 3 of 10

Question 4 of 10

4. Which is the more preferred way tool of effective data management strategy and decision making?

BIDS

SSMS

SSRS

Excel

Question 4 of 10

Question 5 of 10

5. Which of the following table stores history detail for log shipping jobs?

log_shipping_monitor_alert

log_shipping_monitor_primary

none of the mentioned

log_shipping_monitor_history_detail

Question 5 of 10

Question 6 of 10

6. Which of the following is Policy-based management view?

sys_policies

syspolicy_policies

syspolicy

all of the mentioned

Question 6 of 10

Question 7 of 10

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

DQS

All of the mentioned

SSAS

SSRS

Question 7 of 10

Question 8 of 10

8. Which of the following wizard provides creation logins on the destination server?

Move Database

Detach database

Copy Database

Attach database

Question 8 of 10

Question 9 of 10

9. Which of the following statement is used for changing Recovery Model with T-SQL?

ALTER TABLE

ALTER COLUMN

None of the mentioned

ALTER DATABASE

Question 9 of 10

Question 10 of 10

10. What should be done to check to see if data still exists in the Snapshot?

Run Select on Database Snapshot

Run Delete on Database Snapshot

Run Update on Database Snapshot

Run Insert on Database Snapshot

Question 10 of 10