1|Page
IS 301 MIDTERM EXAM WITH CORRECT ACTUAL
QUESTIONS AND CORRECTLY WELL DEFINED
ANSWERS LATEST 2025 ALREADY GRADED A+
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|Page
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|Page
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 EXAM WITH CORRECT ACTUAL
QUESTIONS AND CORRECTLY WELL DEFINED
ANSWERS LATEST 2025 ALREADY GRADED A+
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|Page
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|Page
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
