SQL Server Mock Test 9

10%

Question 1 of 10

1. Which of the following is the process of basing an organization’s actions and decisions on actual measured results of performance?

Institutional performance management

None of the mentioned

Gap analysis

Slice and Dice

Question 1 of 10

Question 2 of 10

2. Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?

Membership

Server

Database

Client

Question 2 of 10

Question 3 of 10

3. ___________ is a deadlock between a statement that is reading and a statement that is performing some form of data modification.

Writer

Reader-Writer

Reader

All of the mentioned

Question 3 of 10

Question 4 of 10

4. Point out the correct statement.

Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database

Long-running uncommitted transactions decrease recovery time for all types of checkpoints

The Database Engine supports two types of checkpoints

All of the mentioned

Question 4 of 10

Question 5 of 10

5. Point out the wrong statement.

Security for assemblies is based on the .NET Framework security model, which is a code-access security model

The SSAS host-level policy is a combination of Analysis Services fixed policy for system assemblies and user-specified policy for user assemblies

Calling a user-defined function in an assembly is performed just like calling an intrinsic function

All of the mentioned

Question 5 of 10

Question 6 of 10

6. Which of the following locking hint is similar to NOLOCK?

PAGLOCK

READUNCOMMITTED

READCOMMITTED

SERIALIZABLE

Question 6 of 10

Question 7 of 10

7. The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.

none of the mentioned

server

user

database

Question 7 of 10

Question 8 of 10

8. Which of the following checkpoint has 'recovery interval' less than zero?

Direct

Automatic

All of the mentioned

Indirect

Question 8 of 10

Question 9 of 10

9. Implicit transactions are maintained by SQL Server for ___________

SELECT

DDL

DML

All of the mentioned

Question 9 of 10

Question 10 of 10

10. Index page deallocation during a ________ operation is always fully logged.

ALTER INDEX

CREATE INDEX

DROP INDEX

None of the mentioned

Question 10 of 10