Section 1

Preview this deck

T/F - Any DENY permission always overrides a granted permission.

Front

Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

1 year ago

Date created

Mar 14, 2020

Cards (20)

Section 1

(20 cards)

T/F - Any DENY permission always overrides a granted permission.

Front

True

Back

All users are automatically a member of the ____ database role.

Front

public

Back

You just hired a new database administrator and you want to give her full access to your SQL server. What role should you assign? a. diskadmin b. securityAdmin c. sysadmin d. db_owner

Front

C

Back

T/F - A user must have permissions to access the files that make up a database in order to use the database.

Front

False

Back

T/F - Multiple differential backups must be restored in the same order as originally created.

Front

False

Back

SQL Server uses Windows ____ to verify that a user is valid before access is allowed.

Front

authentication

Back

Which of the following is not a Transact-SQL command to manage permissions? a. GRANT b. REVOKE c. PERMIT d. DENY

Front

C

Back

Which of the following is not a database permission that can be applied to objects? a. DROP b. SELECT c. INSERT d. UPDATE

Front

A

Back

Which of the following are supported database restore scenarios? a. Restore an entire database from a full backup. b. Restore an entire database from a series of partial backups. c. Restore part of a database using partial backups. d. Restore specific files used by the database

Front

A, C, D

Back

T/F - Use the CREATE ROLE statement to create new roles within a database.

Front

True

Back

T/F - Use the CREATE LOGIN statement to allow a Windows account to access SQL-Server.

Front

True

Back

What role gives full access to an individual database? a. db_owner b. db_accessadmin c. db_securityadmin d. db_ddladmin

Front

A

Back

Use the ____ command to recover data that was accidentally deleted by a user.

Front

restore

Back

A differential backup contains only the data that has ____ since the differential base.

Front

changed

Back

What mode allows both Windows and SQL account logins? a. Any b. Full c. Shared d. Mixed

Front

D

Back

What is a built-in SQL account used in mixed mode that has full access to the SQL server? a. fulladmin b. sa c. admin d. administrator

Front

B

Back

Which of the following is not a level of security supported by SQL Server? a. Server b. Database c. Table d. Task

Front

D

Back

The best method of data recovery is to: a. backup, backup, backup b. use RAID c. use UPS d. use redundant NICs

Front

A

Back

Which of the following is not a type of backup supported by SQL Server? a. Full b. Differential c. File d. Device

Front

D

Back

Use the ____ command to allow users to access objects within the database.

Front

grant

Back