Administration Database

What is used to grant a user account access to a database?

• permission

• right

• password

• encryption key

What role can you give to a user who gives full access to the SQL server and databases?

• root

• system

• sysadmin

• local

What role is automatically granted to all users?

• sysadmin

• root

• public

• standard

What permission would you assign that will remove the permission previously assigned?

• grant

• denied

• revoke

• reset

What is the act of establishing or confirming a user or system identity?

• authentication

• authorization

• auditing

• logging

What fixed role allows you to create logins for the server?

• dbcreator

• diskadmin

• securityadmin

• serveradmin

If you are using mixed mode, what account is the built-in SQL administrator account?

• administrator

• sysadmin

• root

• sa

Which type of backup backs up all changes since the last backup?

• full backup

• differential backup

• incremental backup

• copy backup

Which type of backup backs up only the data in the primary filegroup and specified files or filegroups?

• full backup

• differential backup

• partial backup

• incremental backup

What fixed server role allows you to create, alter, and drop disk files?

• bulkadmin

• dbcreator

• processadmin

• iskadmin