CS6400-Exam 1 UPDATED ACTUAL
Questions and CORRECT Answers
DBMS (Database Management System) - CORRECT ANSWER - is a computerized
system that enables users to create and maintain a database
Meta Data - CORRECT ANSWER - The database definition or descriptive information is
also stored by the DBMS in the form of a database catalog or dictionary
transaction - CORRECT ANSWER - an executing program or process that includes one or
more database accesses, such as reading or updating of database records
requirements specification and analysis - CORRECT ANSWER - The first phase in the
design of the new application for an existing database or design of a brand-new database
Conceptual Design - CORRECT ANSWER - Overview of the system, does not include
hardware or software choices
Logical Design - CORRECT ANSWER - A stage in the design phase that matches the
conceptual design to the requirements of the selected DBMS and is therefore software-
dependent. It is used to translate the conceptual design into the internal model for a selected
database management system.
Physical Design - CORRECT ANSWER - translates the logical design into physical
components. The database design is implemented, populated with actual data, and continuously
maintained to reflect the state of the miniworld.
self-describing data - CORRECT ANSWER - includes the data item names and data
values together in one structure
Data Modeling - CORRECT ANSWER - Defining a database so that it faithfully
represents all key components of an organization's environment. The objective is to explicitly
,capture and store data about every business activity the organization wishes to plan, control, or
evaluate.
operation - CORRECT ANSWER - (also called a function or method)
-The interface (or signature)
-The implementation
program-operation independence - CORRECT ANSWER - User application programs can
operate on the data by invoking these operations through their names and arguments, regardless
of how the operations are implemented
Data Abstraction - CORRECT ANSWER - allows program-data independence and
program-operation independence
view - CORRECT ANSWER - subset of the database or it may contain virtual data that is
derived from the database files but is not explicitly stored.
Concurrency Control - CORRECT ANSWER - A method of dealing with a situation in
which two or more users or applications need to access the same record at the same time.
OLTP (online transaction processing) - CORRECT ANSWER - Database design used for
browsing and manipulating business transaction activity
Isolation - CORRECT ANSWER - ensures that each transaction appears to execute in
isolation from other transactions, even though hundreds of transactions may be executing
concurrently
atomicity - CORRECT ANSWER - ensures that either all the database operations in a
transaction are executed or none are
, 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.
Questions and CORRECT Answers
DBMS (Database Management System) - CORRECT ANSWER - is a computerized
system that enables users to create and maintain a database
Meta Data - CORRECT ANSWER - The database definition or descriptive information is
also stored by the DBMS in the form of a database catalog or dictionary
transaction - CORRECT ANSWER - an executing program or process that includes one or
more database accesses, such as reading or updating of database records
requirements specification and analysis - CORRECT ANSWER - The first phase in the
design of the new application for an existing database or design of a brand-new database
Conceptual Design - CORRECT ANSWER - Overview of the system, does not include
hardware or software choices
Logical Design - CORRECT ANSWER - A stage in the design phase that matches the
conceptual design to the requirements of the selected DBMS and is therefore software-
dependent. It is used to translate the conceptual design into the internal model for a selected
database management system.
Physical Design - CORRECT ANSWER - translates the logical design into physical
components. The database design is implemented, populated with actual data, and continuously
maintained to reflect the state of the miniworld.
self-describing data - CORRECT ANSWER - includes the data item names and data
values together in one structure
Data Modeling - CORRECT ANSWER - Defining a database so that it faithfully
represents all key components of an organization's environment. The objective is to explicitly
,capture and store data about every business activity the organization wishes to plan, control, or
evaluate.
operation - CORRECT ANSWER - (also called a function or method)
-The interface (or signature)
-The implementation
program-operation independence - CORRECT ANSWER - User application programs can
operate on the data by invoking these operations through their names and arguments, regardless
of how the operations are implemented
Data Abstraction - CORRECT ANSWER - allows program-data independence and
program-operation independence
view - CORRECT ANSWER - subset of the database or it may contain virtual data that is
derived from the database files but is not explicitly stored.
Concurrency Control - CORRECT ANSWER - A method of dealing with a situation in
which two or more users or applications need to access the same record at the same time.
OLTP (online transaction processing) - CORRECT ANSWER - Database design used for
browsing and manipulating business transaction activity
Isolation - CORRECT ANSWER - ensures that each transaction appears to execute in
isolation from other transactions, even though hundreds of transactions may be executing
concurrently
atomicity - CORRECT ANSWER - ensures that either all the database operations in a
transaction are executed or none are
, 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.
