Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

WHICH_OF_THE_FOLLOWING_WILL_NOT_RETURN_USER_NAME_OF_CURRENT_SESSION??$

A. CUURENT_USER()
B. USER_NAME()
C. CUSER_NAME()
D. None of the mentioned
Answer» E.
Discussion
2.

Grant__________permission_on_the_stored_procedures_to_database_roles_for_implementing_call_level_security.$

A. EXECUTE
B. EXEC
C. READ
D. WRITE
Answer» B. EXEC
Discussion
3.

Return type of CertName field in vwVisibleLabels is?

A. XML
B. INT
C. NVARCHAR(256)
D. VARCHAR(256)
Answer» D. VARCHAR(256)
Discussion
4.

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 mentioned
Answer» E.
Discussion
5.

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 mentioned
Answer» C. NULL
Discussion
6.

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_GetSecLabelDetails
Answer» D. usp_GetSecLabelDetails
Discussion
7.

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

A. vwVisibleLabels
B. VisibleLabels
C. vwVisibleLabel
D. All of the mentioned
Answer» B. VisibleLabels
Discussion
8.

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()
Answer» C. UserName = CURRENT_USER()
Discussion