CS6400 Database Study Set Questions and Answers
Verified 100% Correct
Database Administrator (DBA) - ✔✔Responsible for authorizing access to the database,
coordinating and monitoring its use, and acquiring software and hardware resources as needed
Database designer - ✔✔responsible for identifying the data to be stored in the database and
for choosing appropriate structures to represent and store this data
Database end user - ✔✔people whose jobs require access to the database for querying,
updating, and generating reports
Naive/parametric end users - ✔✔make up a sizable portion of database end users. Their
main job function revolves around constantly querying and updating the database, using
standard types of queries and updates
Canned transactions - ✔✔standard types of queries and updates
Sophisticated end users - ✔✔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 - ✔✔maintain personal databases by using ready-made program packages
that provide easy-to-use menu-based or graphics-based interfaces.
System analysts - ✔✔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 - ✔✔aka software developers/engineers: implement these
specifications as programs; then they test, debug, document, and maintain these canned
transactions
DBMS system designers and implementers - ✔✔design and implement the DBMS modules
and interfaces as a software package
Modules - ✔✔components of a DBMS
Tool developers - ✔✔design and implement tools
Tools - ✔✔the software packages that facilitate database modeling and design, database
system design, and improved performance. Often purchased separately
Operators and maintenance personnel - ✔✔aka system administrators : responsible for the
actual running and maintenance of the hardware and software environment for the database
system.
Redundancy - ✔✔Storing the same data multiple times.
Data normalization - ✔✔a database design which stores each logical data item in only one
place in the database
Controlled redundancy - ✔✔A capability of a DBMS in order to prohibit inconsistencies
among the files. If data stored in DMBS has no redundancy, you are also guaranteed that you
have consistency.
Denormalization - ✔✔placing all the data together, so that we do not have to search
multiple files to collect related data
, Security and authorization subsystem - ✔✔used to create accounts and to specify account
restrictions
Privileged software - ✔✔certain components of the DBMS that are off-limits to most users,
e.g. software for creating new accounts
Persistent storage - ✔✔storage which survives the termination of program execution and
can later be directly retrieved by another program
Object-oriented database systems - ✔✔stores complex programmatic objects (e.g. structs or
classes) in permanent files
Object-relational impedance mismatch problem - ✔✔a set of conceptual and technical
difficulties that are often encountered when a relational database management system
(RDBMS) is being served by an application program (or multiple application programs) written
in an object-oriented programming language or style, particularly because objects or class
definitions must be mapped to database tables defined by relational schema.
Indexes - ✔✔specialized data structures and search techniques to speed up disk search for
the desired records
Buffering/caching module - ✔✔Maintains parts of the database in main memory buffers
Query processing and optimization module - ✔✔responsible for choosing an efficient query
execution plan for each query based on the existing storage structure
Backup and recovery subsystem - ✔✔responsible for recovering from hardware or software
failures
Verified 100% Correct
Database Administrator (DBA) - ✔✔Responsible for authorizing access to the database,
coordinating and monitoring its use, and acquiring software and hardware resources as needed
Database designer - ✔✔responsible for identifying the data to be stored in the database and
for choosing appropriate structures to represent and store this data
Database end user - ✔✔people whose jobs require access to the database for querying,
updating, and generating reports
Naive/parametric end users - ✔✔make up a sizable portion of database end users. Their
main job function revolves around constantly querying and updating the database, using
standard types of queries and updates
Canned transactions - ✔✔standard types of queries and updates
Sophisticated end users - ✔✔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 - ✔✔maintain personal databases by using ready-made program packages
that provide easy-to-use menu-based or graphics-based interfaces.
System analysts - ✔✔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 - ✔✔aka software developers/engineers: implement these
specifications as programs; then they test, debug, document, and maintain these canned
transactions
DBMS system designers and implementers - ✔✔design and implement the DBMS modules
and interfaces as a software package
Modules - ✔✔components of a DBMS
Tool developers - ✔✔design and implement tools
Tools - ✔✔the software packages that facilitate database modeling and design, database
system design, and improved performance. Often purchased separately
Operators and maintenance personnel - ✔✔aka system administrators : responsible for the
actual running and maintenance of the hardware and software environment for the database
system.
Redundancy - ✔✔Storing the same data multiple times.
Data normalization - ✔✔a database design which stores each logical data item in only one
place in the database
Controlled redundancy - ✔✔A capability of a DBMS in order to prohibit inconsistencies
among the files. If data stored in DMBS has no redundancy, you are also guaranteed that you
have consistency.
Denormalization - ✔✔placing all the data together, so that we do not have to search
multiple files to collect related data
, Security and authorization subsystem - ✔✔used to create accounts and to specify account
restrictions
Privileged software - ✔✔certain components of the DBMS that are off-limits to most users,
e.g. software for creating new accounts
Persistent storage - ✔✔storage which survives the termination of program execution and
can later be directly retrieved by another program
Object-oriented database systems - ✔✔stores complex programmatic objects (e.g. structs or
classes) in permanent files
Object-relational impedance mismatch problem - ✔✔a set of conceptual and technical
difficulties that are often encountered when a relational database management system
(RDBMS) is being served by an application program (or multiple application programs) written
in an object-oriented programming language or style, particularly because objects or class
definitions must be mapped to database tables defined by relational schema.
Indexes - ✔✔specialized data structures and search techniques to speed up disk search for
the desired records
Buffering/caching module - ✔✔Maintains parts of the database in main memory buffers
Query processing and optimization module - ✔✔responsible for choosing an efficient query
execution plan for each query based on the existing storage structure
Backup and recovery subsystem - ✔✔responsible for recovering from hardware or software
failures
