adplus-dvertising

Welcome to the Data Security MCQs Page

Dive deep into the fascinating world of Data Security with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Data Security, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Data Security, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

frame-decoration

Check out the MCQs below to embark on an enriching journey through Data Security. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Data Security. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Data Security MCQs | Page 2 of 4

Discuss
Answer: (c).HAS_PERMS_BY_NAME ( securable , securable_class , permission
[ , sub-securable ] [ , sub-securable_class ] )
Discuss
Answer: (a).In versions of SQL Server through SQL Server 2014, sub-securables cannot use brackets in the form ‘[sub name]’. Use ‘sub name’ instead
Q13.
_________ returns a list of the permissions effectively granted to the principal on a securable.
Discuss
Answer: (b).sys.fn_my_permissions
Discuss
Answer: (b).fn_my_permissions ( securable , ‘securable_class’ )
Discuss
Answer: (b).The SCHEMA securable scope contains the USER securables
Q16.
The schema securable scope contains the following securable is __________
Discuss
Answer: (d).Object
Q17.
Which of the following returns a row for each security principal in a SQL Server database?
Discuss
Answer: (c).sys.database_principals
Q18.
Any SQL Server authentication login can see ________ login name.
Discuss
Answer: (a).Own and sa
Q19.
To add or remove server role membership use ____________
Discuss
Answer: (c).ALTER SERVER ROLE
Q20.
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 ]
} [ ; ]
Discuss
Answer: (c).Specifies the new name of the user-defined server role
Page 2 of 4

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!