Administrating a Database

Question 1

______, like every other aspect of the database
project, must be carefully designed, implemented,
and tested.
Because ______may affect the execution of some
procedures, it must be taken into account when
the project code is being developed.

Answer 1

Security

Question 2

A ______is used to grant an entity (such as a
user access) to an object (such as another user or
a database).

Answer 2

permission

Question 3

In SQL Server, the security model is based on what
is referred to as “_______”.

Answer 3

securables

Question 4

A ____ or ______is the process by which an
individual’s access to a computer system is
controlled by identification of that user using
credentials provided by that user.

Answer 4

login or logon

Question 5

The most common login method is using a
______and ______

Answer 5

username and password

Question 6

A _______ is a logical representation of
a person within a electronic system.

Answer 6

user account

Question 7

A security system that requires two distinct forms of identification in order to access something

Answer 7

Two-Factor Authentication(2FA)

Question 8

SERVER-LEVEL SECURITY:
The three different methods for which a user can
be initially identified include:(3)

Answer 8

– Windows user login
– Membership in a Windows user group
– SQL Server-specific login (if the server uses
mixed-mode security)

Question 9

Each object’s permission is assigned
through either _____, ______, or _____
user login permissions

Answer 9

Granting
Revoking
Denying

Question 10

______ means the user can access
the object

Answer 10

Grant permission

Question 11

______ removes the permission
assigned, regardless of whether it’s deny or
grant.

Answer 11

Revoke permission

Question 11

______ overrides a grant
permission

Answer 11

Deny permission

Question 12

There are three different types of accounts
which are available for the SQL Server
service account(3)

Answer 12

• Local user account
  – Local system account
  –Domain user account

Question 13

_______is the act of establishing or
confirming a user or system identity.

Answer 13

Authentication

Question 14

_________ mode is superior to
mixed mode because users don’t need to
learn yet another password and because it
leverages the security design of the network.

Answer 14

Windows Authentication

Question 15

SQL servers also support _____ _____, which
allows you to connect to the SQL server using
Windows authentication or SQL Server
authentication.

Answer 15

mixed mode

Question 16

• A SQL Server login account and related passwords
  are defined on the ____ ____ and are not related
  to Active Directory or Windows accounts

Answer 16

SQL server

Question 17

Associated with SQL authentication is the ___ _______, the built-in SQL administrator account
associated with SQL authentication.

Answer 17

sa account

Question 18

SQL Server includes fixed, predefined server roles:(8)

Answer 18

– Bulkadmin
– Dbcreator
– Diskadmin
– Processadmin
– Securityadmin
– Serveradmin
– Setupadmin
– Sysadmin

Question 19

Any user who wishes to access a database but has
not been declared a user within the database will
automatically be granted the user privileges of the
___________.

Answer 19

guest user

Question 20

The ___ _____ account is not actually created
when a database is created. It must be specifically
added in through the SQL Server Management
Studio interface or through a Transact-SQL
statement.

Answer 20

uest user

Question 21

___ ______ are the permissions that allow
a user to act on the database objects (such as
tables, stored procedures, and views):

Answer 21

Object permissions

Question 22

Examples of Object Permissions(6)

Answer 22

– Select
– Insert
– Update
– Delete
– DRI (References)
– Execute

Question 23

In SQL Server databases, users often access
data by going through one or several objects.
*____ ______ apply to views, stored
procedures, and user-defined functions.

Answer 23

Ownership Chains

Question 24

The purpose of a database ______is so that
you have something to restore if data is lost
during a business’s daily routine.

Answer 24

backup

Question 25

A user may accidentally delete a table or a
database administrator may need to ______
multiple tables on different servers in order to
combine them into one database.

Answer 25

restore

Question 26

A ______ contains all the data in a
specific database or set of filegroups or files, and
also enough log to allow for recovering that data.

Answer 26

full backup

Question 27

A _______
contains only the data that has changed since the
differential base.

Answer 27

differential backup

Question 28

An________ is
based on the last backup of the data. An
________contains only the data that has
changed since the last full or _________.

Answer 28

incremental backup

Question 29

______and __________ backups are
designed to provide more flexibility for
backing up databases that contain some
read-only filegroups under the simple
recovery model.

Answer 29

Partial and differential partial backups

Question 30

• The files in a database can be backed up
  and restored individually.
• Using _______ can increase the speed of
  recovery by letting you restore only damaged
  files without requiring you to restore the rest
  of the database.

Answer 30

File Backups

Question 31

• SQL Server backups are created on _______, such as disk files or tape media.
• You can append new backups to any existing
  backups on a device or overwrite any
  existing backups.

Answer 31

Backup Devices