gs gs116 Security - Securables - 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: What is the syntax for HAS_PERMS_BY_NAME in SQL Server 2014?
HAS_PERMS_NAME ( securable_class , permission [ , sub-securable ] [ , sub-securable_class ] ) HAS_PERMS_BY_NAME ( securable , securable_class , permission [ , sub-securable ] [ , sub-securable_class ] ) HAS_PERMS_BY_NAME ( securable , securable_class , permission [ , sub-securable ] [ , sub-securable_class ] ) HAS_PERMS( securable , securable_class , permission [ , sub-securable ] [ , sub-securable_class ] )
Question 2: Point out the correct statement.
In versions of SQL Server through SQL Server 2014, sub-securables cannot use brackets in the form ‘[sub name]’. Use ‘sub name’ instead
HAS_PERMS_BY_NAME returns NULL when the query fails
In ADO.net, the sub-securable_class argument is valid only if the securable_class argument is set to OBJECT
None of the mentioned
Question 3: _________ returns a list of the permissions effectively granted to the principal on a securable.
HAS_PERMS_BY_NAME
sys.fn_my_permissions
sys.fn_permissions
All of the mentioned
Question 4: What is the syntax for fn_my_permissions function in SQL Server 2014?
fn_my_permissions ( securable , securable_class )
fn_my_permissions ( securable , ‘securable_class’ )
fn_my_permissions ( ‘securable’ , securable_class)
fn_my_permissions ( ‘securable’ , ‘securable_class’ )
Question 5: Point out the wrong statement.
The entity that receives permission to a securable is called a principal
The SCHEMA securable scope contains the USER securables
A table is a securable
None of the mentioned
Question 6: The schema securable scope contains the following securable is __________
Contract
Asymmetric key
Schema
Object
Question 7: Which of the following returns a row for each security principal in a SQL Server database?
sys.database_role_members
sys.sql_logins
sys.database_principals
none of the mentioned
Question 8: Any SQL Server authentication login can see ________ login name.
Own and sa
sa
Own
None of the mentioned
Question 9: To add or remove server role membership use ____________
ALTER ROLE
ALTER ANY LOGIN
ALTER SERVER ROLE
None of the mentioned
Question 10: What is the role of WITH NAME in the following code?
ALTER SERVER ROLE server_role_name { [ ADD MEMBER server_principal ] | [ DROP MEMBER server_principal ] | [ WITH NAME = new_server_role_name ] } [ ; ]
Removes the specified server principal from the server role
Adds the specified server principal to the server role
Specifies the new name of the user-defined server role
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
