AIS EXAM 2 EXAM PREP 2026 Q AND A
COMPLETE REVIEW WITH ACCURATE
ANSWERS
◉ Most DBMS packages contain data definition, data manipulation,
and data query languages. Indicate which language would be used
and why.
The inventory serial number field is extended in the inventory
records to allow for recognition of additional inventory items with
serial numbers containing more than 10 digits.
Answer: DDL (alter structure to define new records)
DML (make changes to the records)
◉ Most DBMS packages contain data definition, data manipulation,
and data query languages. Indicate which language would be used
and why.
A user develops a program to print out all purchases made during
the past two weeks.
Answer: DQL
,◉ Most DBMS packages contain data definition, data manipulation,
and data query languages. Indicate which language would be used
and why.
An additional field is added to the fixed-asset records to record the
estimated salvage value of each asset.
Answer: DML (Record salvage values)
DDL (alter structure and define new records
◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
A) Analyzing large amounts of data for strategic decision making is
often referred to as strategic processing.
B) Databases were developed to address the proliferation of master
files, which were created each time a need for information arose.
C) A DBMS manages and controls the interface between stored data
and the application programs that use the data.
D) Since data warehouses are only used for transaction processing,
they are updated in real time rather than periodically.
,E) Few mainframes and servers use database technology, and
database use in personal computers is growing slowly.
Answer: B, C
◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
A) A problem with databases is data inconsistencies, as the same
data is stored in two or more master files.
B) A database system consists of the database, the DBMS, and the
application programs that access the database through the DBMS.
C) Data mining is using queries to investigate hypothesized
relationships among data.
D) A data warehouse is one or more very large databases containing
both detailed and summarized data for a number of years.
E) Data sharing refers to data and the programs that use them being
independent of each other; each can be changed without changing
the other.
Answer: B, D
, ◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
A) Cross-functional analysis refers to combining master files into
larger pools of data so more application programs can access the
data.
B) In the master file approach, data is an organizational resource
used by and managed for the entire organization, not just the
originating department
C) Data warehouses complement transaction processing databases
by providing support for strategic decision making.
D) OLAP is using sophisticated statistical analysis to find
unhypothesized relationships in data.
E) To avoid outdated, incomplete, or erroneous data, management
needs policies and procedures that ensure scrubbed data.
Answer: C, E
◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
COMPLETE REVIEW WITH ACCURATE
ANSWERS
◉ Most DBMS packages contain data definition, data manipulation,
and data query languages. Indicate which language would be used
and why.
The inventory serial number field is extended in the inventory
records to allow for recognition of additional inventory items with
serial numbers containing more than 10 digits.
Answer: DDL (alter structure to define new records)
DML (make changes to the records)
◉ Most DBMS packages contain data definition, data manipulation,
and data query languages. Indicate which language would be used
and why.
A user develops a program to print out all purchases made during
the past two weeks.
Answer: DQL
,◉ Most DBMS packages contain data definition, data manipulation,
and data query languages. Indicate which language would be used
and why.
An additional field is added to the fixed-asset records to record the
estimated salvage value of each asset.
Answer: DML (Record salvage values)
DDL (alter structure and define new records
◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
A) Analyzing large amounts of data for strategic decision making is
often referred to as strategic processing.
B) Databases were developed to address the proliferation of master
files, which were created each time a need for information arose.
C) A DBMS manages and controls the interface between stored data
and the application programs that use the data.
D) Since data warehouses are only used for transaction processing,
they are updated in real time rather than periodically.
,E) Few mainframes and servers use database technology, and
database use in personal computers is growing slowly.
Answer: B, C
◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
A) A problem with databases is data inconsistencies, as the same
data is stored in two or more master files.
B) A database system consists of the database, the DBMS, and the
application programs that access the database through the DBMS.
C) Data mining is using queries to investigate hypothesized
relationships among data.
D) A data warehouse is one or more very large databases containing
both detailed and summarized data for a number of years.
E) Data sharing refers to data and the programs that use them being
independent of each other; each can be changed without changing
the other.
Answer: B, D
, ◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
A) Cross-functional analysis refers to combining master files into
larger pools of data so more application programs can access the
data.
B) In the master file approach, data is an organizational resource
used by and managed for the entire organization, not just the
originating department
C) Data warehouses complement transaction processing databases
by providing support for strategic decision making.
D) OLAP is using sophisticated statistical analysis to find
unhypothesized relationships in data.
E) To avoid outdated, incomplete, or erroneous data, management
needs policies and procedures that ensure scrubbed data.
Answer: C, E
◉ With respect to data warehouses, databases, and files, which of
the following statement(s) is (are) true?
