MS SQL Server - 49 - Managing Permissions MCQ

49 – Managing Permissions MCQ

Best of luck!

1 / 26

1. What is the primary purpose of the SQL Server “GRANT” statement?

To grant permissions to a user or role

To deny access to a database

To create a new database

To revoke permissions from a user

2 / 26

2. In SQL Server, what is the primary function of the “DENY” statement?

To explicitly deny specific permissions to a user or role

To remove a user from a role

To create a new database

To grant permissions to a user

3 / 26

3. Which SQL Server statement is used to remove previously granted permissions from a user or role?

GRANT

DENY

REVOKE

ALLOW

4 / 26

4. What is the primary benefit of using the “GRANT” statement in SQL Server?

To allow users to grant the same permission to others

To create new roles

To assign server-level permissions to users

To deny access to a database

5 / 26

5. In SQL Server, which statement is used to grant EXECUTE permission on a stored procedure to a role?

GRANT EXECUTE ON Procedure TO Role

GRANT EXECUTE ON Role TO Procedure

GRANT EXECUTE TO Role

GRANT Role TO EXECUTE Procedure

6 / 26

6. What is the primary purpose of the “DENY” statement when configuring permissions in SQL Server?

To create a new schema

To assign roles to users

To explicitly deny specific permissions to a user or role

To grant permissions to a user or role

7 / 26

7. Which SQL Server statement is used to revoke a permission previously granted to a user on a securable?

REVOKE SELECT ON Securable FROM User

REVOKE PERMISSION

REVOKE SELECT FROM User ON Securable

REVOKE USER

8 / 26

8. What is the primary purpose of SQL Server Management Studio (SSMS) when managing permissions?

To configure user permissions and roles

To write C# code

To create new databases

To design database schemas

9 / 26

9. In SQL Server Management Studio (SSMS), what window can you use to manage user permissions and roles?

Object Explorer

Query Editor

Activity Monitor

Resource Governor

10 / 26

10. Which SQL Server Management Studio (SSMS) feature allows you to script database objects and permissions for deployment?

Generate Scripts Wizard

Query Designer

Template Explorer

Object Explorer

11 / 26

11. In SQL Server Management Studio (SSMS), what does the “Effective” tab show when configuring permissions?

It shows the currently executing queries.

It displays the server's hardware specifications.

It lists the effective permissions of a user or role on a securable.

It displays the server's IP address.

12 / 26

12. What is the primary benefit of using the “REVOKE” statement in SQL Server?

To remove users from roles

To explicitly deny specific permissions to a user or role

To grant permissions to a user or role

To create a new schema

13 / 26

13. In SQL Server, what statement is used to add a user to a role?

ADD ROLE TO USER

ALTER USER

ADD USER TO ROLE

ALTER ROLE

14 / 26

14. In SQL Server Management Studio (SSMS), what is the purpose of the “Securables” tab when configuring permissions?

To select the objects on which permissions are set

To write T-SQL scripts

To define login credentials

To specify the server name

15 / 26

15. In SQL Server Management Studio (SSMS), what is the purpose of the “Permissions” tab when configuring permissions?

To analyze query performance

To provide a list of all user roles

To simplify the process of assigning and revoking permissions on securables

To change the database collation

16 / 26

16. In SQL Server Management Studio (SSMS), what is the primary benefit of using the “Ownership Chaining” option in database properties?

To control permissions inheritance

To configure server-wide settings

To set the database collation

To adjust hardware configurations

17 / 26

17. In SQL Server Management Studio (SSMS), where can you find the “Effective Permissions” feature?

Query Designer

Object Explorer

Solution Explorer

Database Properties

18 / 26

18. What is the primary benefit of using the “GRANT OPTION” clause when granting permissions in SQL Server?

It provides ownership of the securable.

It grants the permission to execute stored procedures.

It allows the user or role to grant the same permission to others.

It allows the user or role to create new schemas.

19 / 26

19. In SQL Server, which statement is true about the “DENY” statement?

It is used to grant permissions to a user or role.

It is used to explicitly deny specific permissions to a user or role.

It is used to remove a user from a role.

It provides ownership of the securable.

20 / 26

20. What is the primary benefit of using the “REVOKE” statement in SQL Server?

To grant permissions to a user or role.

To remove previously granted permissions from a user or role.

To deny access to a database.

To create new roles.

21 / 26

21. In SQL Server, what is the primary benefit of the “GRANT” statement?

To allow users to grant the same permission to others.

To assign server-level permissions to users.

To create new roles.

To deny access to a database.

22 / 26

22. In SQL Server, what is the primary benefit of the “GRANT OPTION FOR” clause when granting permissions?

It provides ownership of the securable.

It grants the permission to execute stored procedures.

It allows the user to create new schemas.

It enables the user to grant the same permission to others.

23 / 26

23. In SQL Server, what is the primary purpose of managing permissions using SQL Server Management Studio (SSMS)?

To create new databases.

To design database schemas.

To assign and revoke permissions on database objects.

To configure server-wide settings.

24 / 26

24. In SQL Server, what is the primary benefit of the “DENY” statement when configuring permissions?

To create a new schema.

To explicitly deny specific permissions to a user or role.

To grant permissions to a user or role.

To assign roles to users.

25 / 26

25. In SQL Server, which statement is used to revoke previously granted permissions from a user or role?

REMOVE PERMISSION

REVOKE ALL FROM User ON Securable

REVOKE ALL ON Securable FROM User

REVOKE PERMISSION

26 / 26

26. What is the primary benefit of using the “GRANT” statement in SQL Server?

To create new roles.

To allow users to grant the same permission to others.

To assign server-level permissions to users.

To deny access to a database.

Your score is

MS SQL Server – 49 – Managing Permissions MCQ