9640849
Description
Quiz by Hawerth Castro, updated more than 1 year ago
|
Created by Hawerth Castro
over 6 years ago
|
|
Question 1
Question
What is used to grant a user account access to a database?
Answer
-
permission
-
right
-
password
-
encryption key
Question 2
Question
What role can you give to a user who gives full access to the SQL server and databases?
Answer
-
root
-
system
-
sysadmin
-
local
Question 3
Question
What role is automatically granted to all users?
Answer
-
sysadmin
-
root
-
public
-
standard
Question 4
Question
What permission would you assign that will remove the permission previously assigned?
Answer
-
grant
-
denied
-
revoke
-
reset
Question 5
Question
What is the act of establishing or confirming a user or system identity?
Answer
-
authentication
-
authorization
-
auditing
-
logging
Question 6
Question
What fixed role allows you to create logins for the server?
Answer
-
dbcreator
-
diskadmin
-
securityadmin
-
serveradmin
Question 7
Question
If you are using mixed mode, what account is the build-in SQL administrator account?
Answer
-
administrator
-
sysadmin
-
root
-
sa
Question 8
Question
Which type of backup backs up all changes since the last backup?
Answer
-
full backup
-
differential backup
-
incremental backup
-
copy backup
Question 9
Question
Which type of backup backs up only the data in the primary filegroup and specified files or filegroups?
Answer
-
full backup
-
differential backup
-
partial backup
-
incremental backup
Question 10
Question
What fixed server role allows you to create, alter, and drop disk files?
Answer
-
bulkadmin
-
dbcreator
-
processadmin
-
diskadmin
Question 11
Question
Which service account should you use if you need to have network access?
Answer
-
local user account
-
local system account
-
domain user account
-
guest account
Question 12
Question
What fixed database role allows you to have full permission to a database?
Answer
-
sa
-
db_owner
-
db_datareader
-
db_accessadmin
Question 13
Question
What fixed database role would you use to manage database-level security roles and permissions?
Answer
-
sysadmin
-
db_securityadmin
-
db_accessadmin
-
db_datareader
Question 14
Question
What command would you use to grant object permissions?
Answer
-
GRANT
-
USE
-
RUNAS
-
ALLOW
Question 15
Question
If you need to restore a database after an incremental backup, what do you need to do for a restore?
Answer
-
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.
Want to create your own Quizzes for free with GoConqr? Learn more.