1
IS 301 MIDTERM | COMPLETE QUESTIONS WITH
CORRECT ANSWERS | GRADED A+ | VERIFIED
ANSWERS | LATEST VERSIONS 2025
True or False. Database programming languages receive all application requests
and translate them into the complex operations required to fulfill those requests.
- (ANSWER)False
____ relates to the activities that make the database perform more efficiently in
terms of storage and access speed.
Performance tuning
Database design
Query access
Database management - (ANSWER)Performance Tuning
The response of the DBMS to a query is the ____.
ad hoc query
ad hoc response
query result set
integrated view of the data - (ANSWER)query result set
True or False. One disadvantage of a database system over previous data
management approaches is increased costs. - (ANSWER)True
____ exists when different versions of the same data appear in different places.
, 2
Data inconsistency
Data consistency
Better data integration
Improved decision making - (ANSWER)Data inconsistency
True or False. A query language is a procedural language. - (ANSWER)False
True or False. Data processing can be as simple as organizing data to reveal
patterns. - (ANSWER)True
A(n) ____ database is used by an organization and supports many users across
many departments.
desktop
workgroup
enterprise
transactional - (ANSWER)enterprise
True or False. A data warehouse can store data derived from many sources. -
(ANSWER)True
A ____ database supports data distributed across several different sites.
single-user
multiuser
, 3
centralized
distributed - (ANSWER)distributed
Which of the following is NOT part of the acronym CRUD?
Create
Relate
Update
Delete - (ANSWER)Relate
Data is subject to update, insertion, and deletion anomalies. These abnormalities
can be prevented through a process known as ____.
database design
business rule identification
normalization
denormalization - (ANSWER)normalization
True or False. Information implies familiarity, awareness, and understanding
knowledge as it applies to an environment. - (ANSWER)False
Accurate, relevant, and timely information is the key to ____.
data management
good decision making
IS 301 MIDTERM | COMPLETE QUESTIONS WITH
CORRECT ANSWERS | GRADED A+ | VERIFIED
ANSWERS | LATEST VERSIONS 2025
True or False. Database programming languages receive all application requests
and translate them into the complex operations required to fulfill those requests.
- (ANSWER)False
____ relates to the activities that make the database perform more efficiently in
terms of storage and access speed.
Performance tuning
Database design
Query access
Database management - (ANSWER)Performance Tuning
The response of the DBMS to a query is the ____.
ad hoc query
ad hoc response
query result set
integrated view of the data - (ANSWER)query result set
True or False. One disadvantage of a database system over previous data
management approaches is increased costs. - (ANSWER)True
____ exists when different versions of the same data appear in different places.
, 2
Data inconsistency
Data consistency
Better data integration
Improved decision making - (ANSWER)Data inconsistency
True or False. A query language is a procedural language. - (ANSWER)False
True or False. Data processing can be as simple as organizing data to reveal
patterns. - (ANSWER)True
A(n) ____ database is used by an organization and supports many users across
many departments.
desktop
workgroup
enterprise
transactional - (ANSWER)enterprise
True or False. A data warehouse can store data derived from many sources. -
(ANSWER)True
A ____ database supports data distributed across several different sites.
single-user
multiuser
, 3
centralized
distributed - (ANSWER)distributed
Which of the following is NOT part of the acronym CRUD?
Create
Relate
Update
Delete - (ANSWER)Relate
Data is subject to update, insertion, and deletion anomalies. These abnormalities
can be prevented through a process known as ____.
database design
business rule identification
normalization
denormalization - (ANSWER)normalization
True or False. Information implies familiarity, awareness, and understanding
knowledge as it applies to an environment. - (ANSWER)False
Accurate, relevant, and timely information is the key to ____.
data management
good decision making
