AIS CHAPTER 4 QUESTIONS WITH 100%
CORRECT ANSWERS { GUARANTEED
A+}
Database - ✔✔a set of interrelated, centrally coordinated data files that are stored
with as little data redundancy as possible
Database Management System (DBMS) - ✔✔the program that manages and
controls the data and the interfaces between the data and the application programs
that use the data stored in the database
database system - ✔✔the database, the DBMS, and the application programs that
access the database through the DBMS
Database Administrator (DBA) - ✔✔the person responsible for coordinating,
controlling, and managing the database
, Online Transaction Processing (OLTP) - ✔✔Database containing detailed current
transaction data, usually in third normal form. Focuses on throughput, speed,
availability, concurrency, and recoverability. Often used concurrently by hundreds
of users.
data warehouse - ✔✔very large databases containing detailed and summarized
data for a number of years that are used for analysis rather than transaction
processing
Business Intelligence - ✔✔analyzing large amounts of data for strategic decision
making
Online Analytical Processing (OLAP) - ✔✔using queries to investigate
hypothesized relationships among data
data mining - ✔✔using sophisticated statistical analysis to "discover"
unhypothesized relationships in the data
record layout - ✔✔document that shows the items stored in a file, including the
order and length of the data fields and the type of data stored
logical view - ✔✔how people conceptually organize, view, and understand the
relationships among data items
CORRECT ANSWERS { GUARANTEED
A+}
Database - ✔✔a set of interrelated, centrally coordinated data files that are stored
with as little data redundancy as possible
Database Management System (DBMS) - ✔✔the program that manages and
controls the data and the interfaces between the data and the application programs
that use the data stored in the database
database system - ✔✔the database, the DBMS, and the application programs that
access the database through the DBMS
Database Administrator (DBA) - ✔✔the person responsible for coordinating,
controlling, and managing the database
, Online Transaction Processing (OLTP) - ✔✔Database containing detailed current
transaction data, usually in third normal form. Focuses on throughput, speed,
availability, concurrency, and recoverability. Often used concurrently by hundreds
of users.
data warehouse - ✔✔very large databases containing detailed and summarized
data for a number of years that are used for analysis rather than transaction
processing
Business Intelligence - ✔✔analyzing large amounts of data for strategic decision
making
Online Analytical Processing (OLAP) - ✔✔using queries to investigate
hypothesized relationships among data
data mining - ✔✔using sophisticated statistical analysis to "discover"
unhypothesized relationships in the data
record layout - ✔✔document that shows the items stored in a file, including the
order and length of the data fields and the type of data stored
logical view - ✔✔how people conceptually organize, view, and understand the
relationships among data items
