Related InterviewSolutions

• Which of the following will not return user name of the current session?(a) CUURENT_USER()(b) USER_NAME()(c) CUSER_NAME()(d) None of the mentionedI got this question in semester exam.I'd like to ask this question from Row Level Security topic in chapter Security of SQL Server
• Return type of CertName field in vwVisibleLabels is __________(a) XML(b) INT(c) NVARCHAR(256)(d) VARCHAR(256)This question was addressed to me in an international level competition.I need to ask this question from Row Level Security in portion Security of SQL Server
• The major components of the Label Security Toolkit are _____________(a) Documentation(b) The Label Policy Designer application(c) Examples showing the implementation of row- and cell-level security in different scenarios(d) All of the mentionedI got this question by my college professor while I was bunking the class.I need to ask this question from Row Level Security in chapter Security of SQL Server
• What will the fn_Dominates return if A dominates B where A and B both are security label?(a) 0(b) 1(c) NULL(d) None of the mentionedI got this question by my school principal while I was bunking the class.The query is from Row Level Security topic in section Security of SQL Server
• Point out the wrong statement.(a) usp_EnableCellVisibility opens all the symmetric keys that are mapped to security labels(b) usp_DisableCellVisibility opens all the symmetric keys that were previously opened(c) On SQL Server 2012 you can use the Contained Database feature to create a user without a login(d) No arguments are available for usp_EnableCellVisibilityThis question was posed to me by my college director while I was bunking the class.Asked question is from Row Level Security topic in division Security of SQL Server
• Which of the following retrieves a SecurityLabel instance describing the subject label of the current database user?(a) fn_Dominates(b) usp_GetUserLabel(c) usp_GetCurrentUserLabel(d) usp_GetSecLabelDetailsThe question was asked during an online exam.Origin of the question is Row Level Security in section Security of SQL Server
• View that contains the list of all the security labels present in the database are __________(a) vwVisibleLabels(b) VisibleLabels(c) vwVisibleLabel(d) All of the mentionedThis question was posed to me in homework.Asked question is from Row Level Security topic in section Security of SQL Server
• Point out the correct statement.(a) Implementing row level security based on security labels is possible in SQL Server 2008(b) A security label is a marking that describes the securable content of an item(c) Row-level permissions are used for applications that store information in a single table(d) None of the mentionedThis question was addressed to me by my school principal while I was bunking the class.This question is from Row Level Security topic in portion Security of SQL Server
• Which of the following condition in the where clause will return the login identification name of the user?(a) UserName = SUSER_NAME()(b) UserName = SUSER_SNAME()(c) UserName = CURRENT_USER()(d) UserName = USER()I had been asked this question in exam.The origin of the question is Row Level Security in chapter Security of SQL Server
• Any SQL Server authentication login can see ________ login name.(a) Own and sa(b) sa(c) Own(d) None of the mentionedI have been asked this question in an online interview.Asked question is from Securables topic in section Security of SQL Server