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

This section includes 4 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.

THE_SCHEMA_SECURABLE_SCOPE_CONTAINS_THE_FOLLOWING_SECURABLES:?$

A. Contract
B. Asymmetric key
C. Schema
D. Object
Answer» D. Object
Discussion
2.

Which_of_the_following_returns_a_row_for_each_security_principal_in_a_SQL_Server_database_?$

A. sys.database_role_members
B. sys.sql_logins
C. sys.database_principals
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
3.

Syntax for fn_my_permissions function in SQL Server 2014 is :

A. fn_my_permissions ( securable , securable_class )
B. fn_my_permissions ( securable , ‘securable_class’ )
C. fn_my_permissions ( ‘securable’ , securable_class)
D. fn_my_permissions ( ‘securable’ , ‘securable_class’ )
Answer» D. fn_my_permissions ( ‚Äö√Ñ√∂‚àö√ë‚àö‚â§securable‚Äö√Ñ√∂‚àö√ë‚àö¬• , ‚Äö√Ñ√∂‚àö√ë‚àö‚â§securable_class‚Äö√Ñ√∂‚àö√ë‚àö¬• )
Discussion
4.

_________ returns a list of the permissions effectively granted to the principal on a securable.

A. HAS_PERMS_BY_NAME
B. sys.fn_my_permissions
C. sys.fn_permissions
D. All of the mentioned
Answer» E.
Discussion