Hawerth Castro
Quiz by , created more than 1 year ago

Database Fundamentals Quizzes preparing to certification

36
0
0
Hawerth Castro
Created by Hawerth Castro over 7 years ago
Close

CET_TARDE - MTA Database - DIAGNOSTIC5

Question 1 of 15

1

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

Select one of the following:

  • permission

  • right

  • password

  • encryption key

Explanation

Question 2 of 15

1

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

Select one of the following:

  • root

  • system

  • sysadmin

  • local

Explanation

Question 3 of 15

1

What role is automatically granted to all users?

Select one of the following:

  • sysadmin

  • root

  • public

  • standard

Explanation

Question 4 of 15

1

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

Select one of the following:

  • grant

  • denied

  • revoke

  • reset

Explanation

Question 5 of 15

1

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

Select one of the following:

  • authentication

  • authorization

  • auditing

  • logging

Explanation

Question 6 of 15

1

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

Select one of the following:

  • dbcreator

  • diskadmin

  • securityadmin

  • serveradmin

Explanation

Question 7 of 15

1

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

Select one of the following:

  • administrator

  • sysadmin

  • root

  • sa

Explanation

Question 8 of 15

1

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

Select one of the following:

  • full backup

  • differential backup

  • incremental backup

  • copy backup

Explanation

Question 9 of 15

1

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

Select one of the following:

  • full backup

  • differential backup

  • partial backup

  • incremental backup

Explanation

Question 10 of 15

1

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

Select one of the following:

  • bulkadmin

  • dbcreator

  • processadmin

  • diskadmin

Explanation

Question 11 of 15

1

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

Select one of the following:

  • local user account

  • local system account

  • domain user account

  • guest account

Explanation

Question 12 of 15

1

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

Select one of the following:

  • sa

  • db_owner

  • db_datareader

  • db_accessadmin

Explanation

Question 13 of 15

1

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

Select one of the following:

  • sysadmin

  • db_securityadmin

  • db_accessadmin

  • db_datareader

Explanation

Question 14 of 15

1

What command would you use to grant object permissions?

Select one of the following:

  • GRANT

  • USE

  • RUNAS

  • ALLOW

Explanation

Question 15 of 15

1

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

Select one of the following:

  • 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.

Explanation