Ch 15 – Multiple Choice – Flashcards
Unlock all answers in this set
Unlock answersquestion
In the context of the data-information-decision cycle, decisions made by high-level managers trigger actions in an organization's:
answer
lower levels
question
At the level of middle management, the database must be able to _____
answer
provide the data necessary for tactical decisions and planning
question
When introducing a database into an organization, the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions. This leads to a _____ impact of the new database system.
answer
cultural
question
The person responsible for the control of the centralized and shared database is the database _____
answer
administrator
question
Database administration operations are commonly defined and divided according to the phases of the _____
answer
DBLC
question
A data administrator is also known as an _____
answer
information resource manager
question
The _____ administrator is responsible for strategic planning
answer
data
question
Coordinating, monitoring, and allocating database administration resources is included in a DBA's _____ role
answer
managerial
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
question
_____ are general statements of direction or action that communicate and support DBA goals
answer
policies
question
_____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity
answer
standards
question
_____ are written instructions that describe a series of steps to be followed during the performance of a given activity
answer
procedures
question
"All users must have passwords" is an example of a _____
answer
policy
question
Instructions to create a password are an example of a _____
answer
procedure
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
question
45. "A password must have a minimum of five characters" is an example of a _____
answer
standard
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
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
question
_____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications
answer
system support
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
question
When performing user access management, a DBA defines each user to the database at the _____ levels
answer
operating system and DBMS
question
User-access management is a subset of _____
answer
authorization management
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
question
An _____ data dictionary is automatically updated by the DBMS with every database access
answer
active
question
A _____ data dictionary is not updated automatically and usually requires a batch process to be run
answer
passive
question
_____ CASE tools provide support for the planning, analysis, and design phases
answer
front-end
question
_____ CASE tools provide support for the coding and implementation phases
answer
back-end
question
The _____ component of a CASE tool produces the information system's input/output formats
answer
screen painter and report generator
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)
