Administrating a Database

1.

1 point

What fixed database role would you use to manage database-level security roles and permissions?

db_accessadmin

sysadmin

db_datareader

db_securityadmin

2.

1 point

What command would you use to grant object permissions?

RUNAS

USE

GRANT

ALLOW

3.

1 point

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

sysadmin

system

local

root

4.

1 point

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

differential backup

partial backup

incremental backup

full backup

5.

1 point

A ____________________ restores the database in stages.

6.

1 point

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

sa

root

sysadmin

administrator

7.

1 point

What command would you use to remove a user from a SQL server?

8.

1 point

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

authentication

auditing

logging

authorization

9.

1 point

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

full backup

incremental backup

differential backup

copy backup

10.

1 point

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

dbcreator

securityadmin

diskadmin

serveradmin

11.

1 point

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

processadmin

bulkadmin

dbcreator

diskadmin

12.

1 point

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

grant

reset

revoke

denied

13.

1 point

What role is automatically granted to all users?

root

sysadmin

standard

public

14.

1 point

What fixed database role allows you to have full permission to a database?

sa

db_accessadmin

db_owner

db_datareader

15.

1 point

What command is used to create a user called server\user1?

16.

1 point

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

permission

right

password

encryption key

17.

1 point

If you need to restore a database after an incremental backup, what do you need to do for a restore?

Restore the last incremental backup.

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.

18.

1 point

Which fixed server roles can create, alter, and drop databases?

19.

1 point

In mixed mode, what two types of logins are allowed?

Guest Logins

Server Logins

System Logins

Windows Logins

SQL Logins

20.

1 point

Which service account should you use if you need to have network access?

domain user account

guest account

local user account

local system account