Question 1 : Grant ________ permission on the stored procedures to database roles for implementing call level security.
1. EXECUTE
2. EXEC
3. READ
4. WRITE
View Answer   Discuss with Members

Question 2 : Which of the following will not return user name of current session?
1. CUURENT_USER()
2. USER_NAME()
3. CUSER_NAME()
4. None of the mentioned
View Answer   Discuss with Members

Question 3 : Return type of CertName field in vwVisibleLabels is:
1. XML
2. INT
3. NVARCHAR(256)
4. VARCHAR(256)
View Answer   Discuss with Members

Question 4 : The major components of the Label Security Toolkit are:
1. Documentation
2. The Label Policy Designer application
3. Examples showing the implementation of row- and cell-level security in different scenarios
4. All of the mentioned
View Answer   Discuss with Members

Question 5 : What will the fn_Dominates return if A dominates B where A and B both are security label?
1. 0
2. 1
3. NULL
4. None of the mentioned
View Answer   Discuss with Members

Question 6 : Point out the wrong statement :
1. usp_EnableCellVisibility opens all the symmetric keys that are mapped to security labels
2. usp_DisableCellVisibility opens all the symmetric keys that were previously opened
3. On SQL Server 2012 you can use the Contained Database feature to create a user without a login
4. No arguments are available for usp_EnableCellVisibility
5.
View Answer   Discuss with Members

Question 7 : Which of the following retrieves a SecurityLabel instance describing the subject label of the current database user?
1. fn_Dominates
2. usp_GetUserLabel
3. usp_GetCurrentUserLabel
4. usp_GetSecLabelDetails
View Answer   Discuss with Members

Question 8 : View that contains the list of all the security labels present in the database:
1. vwVisibleLabels
2. VisibleLabels
3. vwVisibleLabel
4. All of the mentioned
View Answer   Discuss with Members

Question 9 : Point out the correct statement:
1. Implementing row level security based on security labels is possible in SQL Server 2008
2. A security label is a marking that describes the securable content of an item
3. Row-level permissions are used for applications that store information in a single table
4. None of the mentioned
View Answer   Discuss with Members

Question 10 : Which of the following condition in the where clause will return the login identification name of the user?
1. UserName = SUSER_NAME()
2. UserName = SUSER_SNAME()
3. UserName = CURRENT_USER()
4. UserName = USER()
View Answer   Discuss with Members