gs gs116 Security - Row Level Security in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Security. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following condition in the where clause will return the login identification name of the user?
UserName = SUSER_NAME()
UserName = SUSER_SNAME()
UserName = CURRENT_USER()
UserName = USER()
Question 2: Point out the correct statement.
Implementing row level security based on security labels is possible in SQL Server 2008
A security label is a marking that describes the securable content of an item
Row-level permissions are used for applications that store information in a single table
None of the mentioned
Question 3: View that contains the list of all the security labels present in the database are __________
vwVisibleLabels
VisibleLabels
vwVisibleLabel
All of the mentioned
Question 4: Which of the following retrieves a SecurityLabel instance describing the subject label of the current database user?
fn_Dominates
usp_GetUserLabel
usp_GetCurrentUserLabel
usp_GetSecLabelDetails
Question 5: Point out the wrong statement.
usp_EnableCellVisibility opens all the symmetric keys that are mapped to security labels
usp_DisableCellVisibility opens all the symmetric keys that were previously opened
On SQL Server 2012 you can use the Contained Database feature to create a user without a login
No arguments are available for usp_EnableCellVisibility
Question 6: What will the fn_Dominates return if A dominates B where A and B both are security label?
0
1
NULL
None of the mentioned
Question 7: The major components of the Label Security Toolkit are _____________
Documentation
The Label Policy Designer application
Examples showing the implementation of row- and cell-level security in different scenarios
All of the mentioned
Question 8: Return type of CertName field in vwVisibleLabels is __________
XML
INT
NVARCHAR(256)
VARCHAR(256)
Question 9: Which of the following will not return user name of the current session?
CUURENT_USER()
USER_NAME()
CUSER_NAME()
None of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
