SQL Server Mock Test 6

10%

Question 1 of 10

1. Point out the wrong statement.

The command CHECKDB checks the logical and physical integrity of all the objects in the specified database

The command DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database

The command DBCC CHECK checks the logical and physical integrity of all the objects in the specified database

None of the mentioned

Question 1 of 10

Question 2 of 10

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

All of the mentioned

SSAS

SSRS

SSIS

Question 2 of 10

Question 3 of 10

3. No log backups is a feature of __________ recovery model.

Simple

Full

Bulk-logged

All of the mentioned

Question 3 of 10

Question 4 of 10

4. Create a Database Maintenance Plan that creates a ________ backup within SQL Server.

Full

Snapshot

None of the mentioned

Partial

Question 4 of 10

Question 5 of 10

5. An alert can respond to one of the following conditions?

Whenever SQL Server Agent starts

On a recurring schedule

All of the mentioned

SQL Server performance conditions

Question 5 of 10

Question 6 of 10

6. Which of the following action cannot be performed with MDS?

All of the mentioned

Export members for your supporting entities

Create entities

Create attributes for your entities

Question 6 of 10

Question 7 of 10

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

RESTORE DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

RESTORE Snapshot <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

None of the mentioned

REST DATABASE <database_name> FROM DATABASE_SNAPSHOT = <database_snapshot_name>

Question 7 of 10

Question 8 of 10

8. Point out the correct statement.

Log shipping cannot be combined with other disaster recovery options such as AlwaysOn Availability Groups

The restore job can be delayed until all users disconnect themselves

None of the mentioned

SQL Server log shipping has high cost in human

Question 8 of 10

Question 9 of 10

9. Which of the following stored procedure is used for detachment of database?

sp_replicationdb

all of the mentioned

sp_replicationdboption

sp_replicationoption

Question 9 of 10

Question 10 of 10

10. Policy based management views are present in _________ database.

Tempdb

Msdb

Master

Model

Question 10 of 10