CS 6400 Exam REVIEW
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
Database Administrator (DBA) - CORRECT ANSWER-the person responsible for coordinating,
controlling, and managing the database
Database designers - CORRECT ANSWER-are responsible for identifying the data to be stored in
the database and for choosing appropriate structures to represent and store this data
End users - CORRECT ANSWER-are the people whose jobs require access to the database for
querying, updating, and generating reports; the database primarily exists for their use.
Parametric End Users - CORRECT ANSWER-Their main job function revolves around constantly
querying and updating the database, using standard types of queries and updates
Sophisticated end users - CORRECT ANSWER-include engineers, scientists, business analysts,
and others who thoroughly familiarize themselves with the facilities of the DBMS in order to
implement their own applications to meet their complex requirements.
Standalone users - CORRECT ANSWER-maintain personal databases by using ready-made
program packages that provide easy-to-use menu-based or graphics-based interfaces. An
,example is the user of a financial software package that stores a variety of personal financial
data.
Casual end users - CORRECT ANSWER-occasionally access the database, but they may need
different information each time.
System analysts - CORRECT ANSWER-determine the requirements of end users, especially naive
and parametric end users, and develop specifications for standard canned transactions that
meet these requirements.
Application programmers - CORRECT ANSWER-implement these specifications as programs;
then they test, debug, document, and maintain these canned transactions.
redundancy - CORRECT ANSWER-storing the same data multiple times
data normalization - CORRECT ANSWER-database design that stores each logical data item—
such as a student's name or birth date—in only one place in the database.
Controlled Redundancy - CORRECT ANSWER-maintains replicas or exact copies.
Denormalization - CORRECT ANSWER-The process of transforming normalized relations into
non-normalized physical record specifications
Persistent Storage - CORRECT ANSWER-The storage of data in a non-volatile storage medium
such as a hard drive. In the absence of persistent data storage, data would only be stored in
RAM (random access memory) and would be lost whenever the device lost power.
impedance mismatch problem - CORRECT ANSWER-data structures provided by the DBMS were
incompatible with the programming language's data structures
, Indexes - CORRECT ANSWER-Auxiliary files for efficiently executing queries and updates
buffering or caching module - CORRECT ANSWER-maintains parts of the database in main
memory buffers
query processing and optimization module - CORRECT ANSWER-responsible for choosing an
efficient query execution plan for each query based on the existing storage structures.
backup and recovery subsystem - CORRECT ANSWER-provide facilities for recovering from
hardware or software failures
integrity constraints - CORRECT ANSWER-rules that help ensure the quality of information
Referential Integrity - CORRECT ANSWER-A rule that prevents orphaned records.
deductive database systems - CORRECT ANSWER-provide capabilities for defining deduction
rules for inferencing new information from the stored database facts
Triggers - CORRECT ANSWER-is a form of a rule activated by updates to the table, which results
in performing some additional operations to some other tables, sending messages, and so on.
stored procedures - CORRECT ANSWER-More involved procedures to enforce rules
active database systems - CORRECT ANSWER-provide active rules that can automatically initiate
actions when certain events and conditions occur
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
Database Administrator (DBA) - CORRECT ANSWER-the person responsible for coordinating,
controlling, and managing the database
Database designers - CORRECT ANSWER-are responsible for identifying the data to be stored in
the database and for choosing appropriate structures to represent and store this data
End users - CORRECT ANSWER-are the people whose jobs require access to the database for
querying, updating, and generating reports; the database primarily exists for their use.
Parametric End Users - CORRECT ANSWER-Their main job function revolves around constantly
querying and updating the database, using standard types of queries and updates
Sophisticated end users - CORRECT ANSWER-include engineers, scientists, business analysts,
and others who thoroughly familiarize themselves with the facilities of the DBMS in order to
implement their own applications to meet their complex requirements.
Standalone users - CORRECT ANSWER-maintain personal databases by using ready-made
program packages that provide easy-to-use menu-based or graphics-based interfaces. An
,example is the user of a financial software package that stores a variety of personal financial
data.
Casual end users - CORRECT ANSWER-occasionally access the database, but they may need
different information each time.
System analysts - CORRECT ANSWER-determine the requirements of end users, especially naive
and parametric end users, and develop specifications for standard canned transactions that
meet these requirements.
Application programmers - CORRECT ANSWER-implement these specifications as programs;
then they test, debug, document, and maintain these canned transactions.
redundancy - CORRECT ANSWER-storing the same data multiple times
data normalization - CORRECT ANSWER-database design that stores each logical data item—
such as a student's name or birth date—in only one place in the database.
Controlled Redundancy - CORRECT ANSWER-maintains replicas or exact copies.
Denormalization - CORRECT ANSWER-The process of transforming normalized relations into
non-normalized physical record specifications
Persistent Storage - CORRECT ANSWER-The storage of data in a non-volatile storage medium
such as a hard drive. In the absence of persistent data storage, data would only be stored in
RAM (random access memory) and would be lost whenever the device lost power.
impedance mismatch problem - CORRECT ANSWER-data structures provided by the DBMS were
incompatible with the programming language's data structures
, Indexes - CORRECT ANSWER-Auxiliary files for efficiently executing queries and updates
buffering or caching module - CORRECT ANSWER-maintains parts of the database in main
memory buffers
query processing and optimization module - CORRECT ANSWER-responsible for choosing an
efficient query execution plan for each query based on the existing storage structures.
backup and recovery subsystem - CORRECT ANSWER-provide facilities for recovering from
hardware or software failures
integrity constraints - CORRECT ANSWER-rules that help ensure the quality of information
Referential Integrity - CORRECT ANSWER-A rule that prevents orphaned records.
deductive database systems - CORRECT ANSWER-provide capabilities for defining deduction
rules for inferencing new information from the stored database facts
Triggers - CORRECT ANSWER-is a form of a rule activated by updates to the table, which results
in performing some additional operations to some other tables, sending messages, and so on.
stored procedures - CORRECT ANSWER-More involved procedures to enforce rules
active database systems - CORRECT ANSWER-provide active rules that can automatically initiate
actions when certain events and conditions occur
