CS6400 – EXAM 1 EXAM WITH CORRECT
ACTUAL QUESTIONS AND CORRECTLY
WELL DEFINED ANSWERS LATEST
ALREADY GRADED A+
System analysts - ANSWERS-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 - ANSWERS-implement these
specifications as programs; then they test, debug,
document, and maintain these canned transactions.
redundancy - ANSWERS-storing the same data multiple
times
data normalization - ANSWERS-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 - ANSWERS-maintains replicas or
exact copies.
Denormalization - ANSWERS-The process of transforming
normalized relations into non-normalized physical record
specifications
Persistent Storage - ANSWERS-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 - ANSWERS-data structures
provided by the DBMS were incompatible with the
programming language's data structures
Indexes - ANSWERS-Auxiliary files for efficiently executing
queries and updates
buffering or caching module - ANSWERS-maintains parts of
the database in main memory buffers
, query processing and optimization module - ANSWERS-
responsible for choosing an efficient query execution plan
for each query based on the existing storage structures.
backup and recovery subsystem - ANSWERS-provide
facilities for recovering from hardware or software failures
integrity constraints - ANSWERS-rules that help ensure the
quality of information
Referential Integrity - ANSWERS-A rule that prevents
orphaned records.
deductive database systems - ANSWERS-provide capabilities
for defining deduction rules for inferencing new information
from the stored database facts
Triggers - ANSWERS-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.
ACTUAL QUESTIONS AND CORRECTLY
WELL DEFINED ANSWERS LATEST
ALREADY GRADED A+
System analysts - ANSWERS-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 - ANSWERS-implement these
specifications as programs; then they test, debug,
document, and maintain these canned transactions.
redundancy - ANSWERS-storing the same data multiple
times
data normalization - ANSWERS-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 - ANSWERS-maintains replicas or
exact copies.
Denormalization - ANSWERS-The process of transforming
normalized relations into non-normalized physical record
specifications
Persistent Storage - ANSWERS-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 - ANSWERS-data structures
provided by the DBMS were incompatible with the
programming language's data structures
Indexes - ANSWERS-Auxiliary files for efficiently executing
queries and updates
buffering or caching module - ANSWERS-maintains parts of
the database in main memory buffers
, query processing and optimization module - ANSWERS-
responsible for choosing an efficient query execution plan
for each query based on the existing storage structures.
backup and recovery subsystem - ANSWERS-provide
facilities for recovering from hardware or software failures
integrity constraints - ANSWERS-rules that help ensure the
quality of information
Referential Integrity - ANSWERS-A rule that prevents
orphaned records.
deductive database systems - ANSWERS-provide capabilities
for defining deduction rules for inferencing new information
from the stored database facts
Triggers - ANSWERS-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.
