NEW
Font size
WorksheetsAdministration Database
Total questions: 15
Worksheet time: 5mins
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
Which service account should you use if you need to have network access?
local user account
local system account
domain user account
guest account
What fixed database role allows you to have full permission to a database?
sa
db_owner
db_datareader
db_accessadmin
What fixed database role would you use to manage database-level security roles and permissions?
sysadmin
db_securityadmin
db_accessadmin
db_datareader
What command would you use to grant object permissions?
GRANT
USE
RUNAS
ALLOW
If you need to restore a database after an incremental backup, what do you need to do for a restore?
Restore the full backup and the first incremental backup.
Restore the full backup and the last incremental backup.
Restore the full backup and all the incremental backups since the last full backup.
Restore the last incremental backup.
