CS6400-Exam 1 Questions With 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. | | | |
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. | | | |
