Ch 15 – Multiple Choice – Flashcards
29 test answers
Unlock all answers in this set
Unlock answers 29question
Database administration operations are commonly defined and divided according to the phases of the _____
answer
DBLC
Unlock the answer
question
A data administrator is also known as an _____
answer
information resource manager
Unlock the answer
question
The _____ administrator is responsible for strategic planning
answer
data
Unlock the answer
question
Coordinating, monitoring, and allocating database administration resources is included in a DBA's _____ role
answer
managerial
Unlock the answer
question
The _____ role of a DBA covers activities that involve evaluating, selecting, installing, and maintaining a DBMS and its related utilities and applications
answer
technical
Unlock the answer
question
_____ are general statements of direction or action that communicate and support DBA goals
answer
policies
Unlock the answer
question
_____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity
answer
standards
Unlock the answer
question
_____ are written instructions that describe a series of steps to be followed during the performance of a given activity
answer
procedures
Unlock the answer
question
"All users must have passwords" is an example of a _____
answer
policy
Unlock the answer
question
Instructions to create a password are an example of a _____
answer
procedure
Unlock the answer
question
In the context of data backup and recovery, the activities of a _____ includes the DBA operations that are classified as disaster management
answer
database security officer
Unlock the answer
question
45. "A password must have a minimum of five characters" is an example of a _____
answer
standard
Unlock the answer
question
Which of the following is a reason why a DBMS's daily operations must be clearly documented?
answer
documentation of the daily operations help pinpoint causes and solutions of database problems
Unlock the answer
question
An _____ plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time
answer
access
Unlock the answer
question
_____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications
answer
system support
Unlock the answer
question
_____ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose
answer
confidentiality
Unlock the answer
question
When performing user access management, a DBA defines each user to the database at the _____ levels
answer
operating system and DBMS
Unlock the answer
question
User-access management is a subset of _____
answer
authorization management
Unlock the answer
question
In the context of database usage monitoring, an _____ is a file that automatically records a brief description of the database operations performed by all users
answer
audit log
Unlock the answer
question
An _____ data dictionary is automatically updated by the DBMS with every database access
answer
active
Unlock the answer
question
A _____ data dictionary is not updated automatically and usually requires a batch process to be run
answer
passive
Unlock the answer
question
_____ CASE tools provide support for the planning, analysis, and design phases
answer
front-end
Unlock the answer
question
_____ CASE tools provide support for the coding and implementation phases
answer
back-end
Unlock the answer
question
The _____ component of a CASE tool produces the information system's input/output formats
answer
screen painter and report generator
Unlock the answer
question
_____ allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals
answer
information engineering (IE)
Unlock the answer
