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.