SQL Server Interview Questions - 25 | Snaprecruit.com

SQL Server Interview Questions - 25 | Snaprecruit.com

SQL Server interview questions part 25

SQL Server interview questions part 25

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. You cannot use the ____________ statement to enable Resource Governor when in a user transaction.

Correct Answer is : ALTER RESOURCE GOVERNOR

2. Enabling the Resource Governor requires _________ permission.

Correct Answer is : CONTROL SERVER

3. Point out the wrong statement :

Correct Answer is : A resource group serves as a container for session requests that have similar classification criteria

4. Which of the following query enables the Resource Governor ?

Correct Answer is : ALTER RESOURCE GOVERNOR RECONFIGURE;

5. Which of the following query disables the resource governor ?

Correct Answer is : ALTER RESOURCE GOVERNOR DISABLE;

6. ____________ is a hard cap limit on the CPU bandwidth for all requests in the resource pool.

Correct Answer is : CAP_CPU_PERCENT

7. ___________ lets you affinitize a resource pool to one or more schedulers or NUMA nodes for greater isolation of CPU resources.

Correct Answer is : AFFINITY

8. Which of the following formula is used for calculating the effective MAX% ?

Correct Answer is : min(X,Y)

9. Which of the following condition in the where clause will return the login identification name of the user?

Correct Answer is : UserName = SUSER_SNAME()

10. Point out the correct statement:

Correct Answer is : Row-level permissions are used for applications that store information in a single table

11. View that contains the list of all the security labels present in the database:

Correct Answer is : vwVisibleLabels

12. Which of the following retrieves a SecurityLabel instance describing the subject label of the current database user?

Correct Answer is : usp_GetCurrentUserLabel

13. Point out the wrong statement :

Correct Answer is : usp_DisableCellVisibility opens all the symmetric keys that were previously opened

14. What will the fn_Dominates return if A dominates B where A and B both are security label?

Correct Answer is : 1

15. The major components of the Label Security Toolkit are:

Correct Answer is : All of the mentioned

16. Return type of CertName field in vwVisibleLabels is:

Correct Answer is : NVARCHAR(256)

17. Which of the following will not return user name of current session?

Correct Answer is : None of the mentioned

18. Grant ________ permission on the stored procedures to database roles for implementing call level security.

Correct Answer is : EXECUTE

19. Point out the correct statement :

Correct Answer is : You can use Source control to audit schema changes

20. Which of the following event is not intrinsically audited?

Correct Answer is : All of the mentioned

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon