MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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. | |
| 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 | |
| 3. |
Return type of CertName field in vwVisibleLabels is? |
| A. | XML |
| B. | INT |
| C. | NVARCHAR(256) |
| D. | VARCHAR(256) |
| Answer» D. VARCHAR(256) | |
| 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. | |
| 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 | |
| 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 | |
| 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 | |
| 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() | |