Practice Questions Security and Permissions

Q1. Members of which database role(s) can give other users access to the database? (Select all correct answers.)

1. sysadmin
2. db_accessadmin
3. db_securityadmin
4. securityadmin

Q2. Members of which roles can back up a database? (Select all correct answers.)

1. dbcreator
2. db_owner
3. serveradmin
4. db_backupoperator

Q3. If you grant permissions on a table to the Public role and later revoke permission from the Windows NT Accounting group, does someone who is a member of that group still have permissions on the table? Select the best answer.

1. Yes, because the REVOKE would only remove a permission that you granted to the Accounting group, so it has no effect.
2. No, because the REVOKE to the group removes the inherited permission to Public.
3. No, because the REVOKE from the Accounting group removes all permissions for members of that group, however they were assigned.
4. You can't tell from the information supplied.

Q4. You want to give all members of the NT Accounting group except the summer interns access to the payroll table. The best way to do this is:

1. Grant database access to the Accounting group, but deny access to the interns.
2. Grant database access to the Accounting group, assign them the correct permissions, and revoke permissions from the interns.
3. Grant database access to the Accounting group, assign them the correct permissions, and deny permissions to the interns.
4. Add another NT group that contains the accountants but not the interns, and give this group the correct access and permissions.