CS6400, Exam1 EXPECTED QUESTIONS WITH VERIFIED
ANSWERS
Question 1.
DBMS (Database Management System)
ANSWER
is a computerized system that enables users to create and maintain a database
Question 2.
Meta Data
ANSWER
The database definition or descriptive information is also stored by the DBMS in the form of a
database catalog or dictionary
Question 3.
transaction
ANSWER
an executing program or process that includes one or more database accesses, such as
reading or updating of database records
Question 4.
requirements specification and analysis
ANSWER
The first phase in the design of the new application for an existing database or design of a
brand-new database
Question 5.
Conceptual Design
ANSWER
Overview of the system, does not include hardware or software choices
,Question 6.
Logical Design
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.
Question 7.
Physical Design
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.
Question 8.
self-describing data
ANSWER
includes the data item names and data values together in one structure
Question 9.
Data Modeling
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.
Question 10.
operation
ANSWER
(also called a function or method)
-The interface (or signature)
-The implementation
, Question 11.
program-operation independence
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
Question 12.
Data Abstraction
ANSWER
allows program-data independence and program-operation independence
Question 13.
view
ANSWER
subset of the database or it may contain virtual data that is derived from the database files but
is not explicitly stored.
Question 14.
Concurrency Control
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.
Question 15.
OLTP (online transaction processing)
ANSWER
Database design used for browsing and manipulating business transaction activity
ANSWERS
Question 1.
DBMS (Database Management System)
ANSWER
is a computerized system that enables users to create and maintain a database
Question 2.
Meta Data
ANSWER
The database definition or descriptive information is also stored by the DBMS in the form of a
database catalog or dictionary
Question 3.
transaction
ANSWER
an executing program or process that includes one or more database accesses, such as
reading or updating of database records
Question 4.
requirements specification and analysis
ANSWER
The first phase in the design of the new application for an existing database or design of a
brand-new database
Question 5.
Conceptual Design
ANSWER
Overview of the system, does not include hardware or software choices
,Question 6.
Logical Design
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.
Question 7.
Physical Design
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.
Question 8.
self-describing data
ANSWER
includes the data item names and data values together in one structure
Question 9.
Data Modeling
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.
Question 10.
operation
ANSWER
(also called a function or method)
-The interface (or signature)
-The implementation
, Question 11.
program-operation independence
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
Question 12.
Data Abstraction
ANSWER
allows program-data independence and program-operation independence
Question 13.
view
ANSWER
subset of the database or it may contain virtual data that is derived from the database files but
is not explicitly stored.
Question 14.
Concurrency Control
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.
Question 15.
OLTP (online transaction processing)
ANSWER
Database design used for browsing and manipulating business transaction activity
