Multiple Choice Questions - SQL Server Permissions
1. GRANT ALTER ON SERVER ROLE::Production TO Jim ;
A) The above example allows Jim to add other permissions to the user-defined server role named Production.
B) The above example allows Jim to add other roles to the user-defined server role named Production.
C) The above example allows Jim to add other logins to the user-defined server role named Production.
D) None of above.
2. The CONTROL SERVER and ALTER ANY SERVER ROLE permissions are sufficient to execute ALTER SERVER ROLE for a fixed server role.
A) True
B) False
3. The following statement returns all Database Engine permissions.
A) SELECT * FROM fn_builtin_permissions (default);
B) SELECT * FROM fn_inbuilt_permissions (default);
C) SELECT * FROM fn_build_permissions (default);
D) SELECT * FROM fn_built_in_permissions (default);
4. Permissions at the schema level can be granted and users the automatically inherit permissions on new objects created in the schema.
A) True
B) False
5. DENY revokes a permission so that it cannot be inherited. DENY takes precedence over all permissions, except DENY does not apply to .......
A) user defined strict permissions
B) object owners
C) members of sysadmin
D) nested roles
6. What Permissions do I have on the DB I am Connected to?
A) SELECT * FROM fn_all_permissions (NULL, 'DATABASE');
B) SELECT * FROM fn_my_permissions (NULL, 'DATABASE');
C) SELECT * FROM fn_permissions (NULL, 'DATABASE');
D) SELECT * FROM fn_ST_permissions (NULL, 'DATABASE');
7. Roles can be nested; Permission sets that are assigned to roles are inherited by ........ members of the role.
A) elected
B) restricted
C) admin
D) all
8. Members of the sysadmin fixed server role and object owners cannot be denied permissions.
A) True
B) False
9. The permissions granted to logins and user-defined fixed server roles can be examined by using the ....... view.
A) sys.credentials
B) sys.server_role_members
C) sys.server_permissions
D) None of above
10. Users with the ........ permission can create new user-defined database roles to represent groups of users with common permissions.
A) CREATE CERTIFICATE
B) CREATE CONTRACT
C) CREATE LOGIN
D) CREATE ROLE
Answers
1. GRANT ALTER ON SERVER ROLE::Production TO Jim ;
A) The above example allows Jim to add other permissions to the user-defined server role named Production.
B) The above example allows Jim to add other roles to the user-defined server role named Production.
C) The above example allows Jim to add other logins to the user-defined server role named Production.
D) None of above.
2. The CONTROL SERVER and ALTER ANY SERVER ROLE permissions are sufficient to execute ALTER SERVER ROLE for a fixed server role.
A) True
B) False
3. The following statement returns all Database Engine permissions.
A) SELECT * FROM fn_builtin_permissions (default);
B) SELECT * FROM fn_inbuilt_permissions (default);
C) SELECT * FROM fn_build_permissions (default);
D) SELECT * FROM fn_built_in_permissions (default);
4. Permissions at the schema level can be granted and users the automatically inherit permissions on new objects created in the schema.
A) True
B) False
5. DENY revokes a permission so that it cannot be inherited. DENY takes precedence over all permissions, except DENY does not apply to .......
A) user defined strict permissions
B) object owners
C) members of sysadmin
D) nested roles
6. What Permissions do I have on the DB I am Connected to?
A) SELECT * FROM fn_all_permissions (NULL, 'DATABASE');
B) SELECT * FROM fn_my_permissions (NULL, 'DATABASE');
C) SELECT * FROM fn_permissions (NULL, 'DATABASE');
D) SELECT * FROM fn_ST_permissions (NULL, 'DATABASE');
7. Roles can be nested; Permission sets that are assigned to roles are inherited by ........ members of the role.
A) elected
B) restricted
C) admin
D) all
8. Members of the sysadmin fixed server role and object owners cannot be denied permissions.
A) True
B) False
9. The permissions granted to logins and user-defined fixed server roles can be examined by using the ....... view.
A) sys.credentials
B) sys.server_role_members
C) sys.server_permissions
D) None of above
10. Users with the ........ permission can create new user-defined database roles to represent groups of users with common permissions.
A) CREATE CERTIFICATE
B) CREATE CONTRACT
C) CREATE LOGIN
D) CREATE ROLE
Answers