CS 6400 Exam
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
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
Implications of Using the Database Approach - CORRECT ANSWER--Potential for Enforcing
Standards
-Reduced Application Development Time
-Flexibility
-Availability of Up-to-Date Information
-Economies of Scale
Extending Database Capabilities for New Applications - CORRECT ANSWER--Scientific
applications that store large amounts of data resulting from scientific experiments
-Storage and retrieval of images
-Storage and retrieval of videos
-Data mining applications that analyze large amounts of data
-Spatial applications that store and analyze spatial locations of data
-Time series applications that store information such as economic data at regular points in time,
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
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
Implications of Using the Database Approach - CORRECT ANSWER--Potential for Enforcing
Standards
-Reduced Application Development Time
-Flexibility
-Availability of Up-to-Date Information
-Economies of Scale
Extending Database Capabilities for New Applications - CORRECT ANSWER--Scientific
applications that store large amounts of data resulting from scientific experiments
-Storage and retrieval of images
-Storage and retrieval of videos
-Data mining applications that analyze large amounts of data
-Spatial applications that store and analyze spatial locations of data
-Time series applications that store information such as economic data at regular points in time,
