IS 301- MIDTERM EXAM
IS 301- MIDTERM EXAM QUESTIONS
AND ANSWERS 2025 GRADED A
True or False. Database programming languages receive all application requests and
translate them into the complex operations required to fulfill those requests. -Correct
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 -Correct 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 -Correct Answer ✔query result set
True or False. One disadvantage of a database system over previous data
management approaches is increased costs. -Correct Answer ✔True
____ exists when different versions of the same data appear in different places.
Data inconsistency
Data consistency
Better data integration
Improved decision making -Correct Answer ✔Data inconsistency
True or False. A query language is a procedural language. -Correct Answer ✔False
True or False. Data processing can be as simple as organizing data to reveal patterns. -
Correct Answer ✔True
A(n) ____ database is used by an organization and supports many users across many
departments.
desktop
workgroup
enterprise
transactional -Correct Answer ✔enterprise
True or False. A data warehouse can store data derived from many sources. -Correct
Answer ✔True
IS 301- MIDTERM EXAM
, IS 301- MIDTERM EXAM
A ____ database supports data distributed across several different sites.
single-user
multiuser
centralized
distributed -Correct Answer ✔distributed
Which of the following is NOT part of the acronym CRUD?
Create
Relate
Update
Delete -Correct 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 -Correct Answer ✔normalization
True or False. Information implies familiarity, awareness, and understanding knowledge
as it applies to an environment. -Correct Answer ✔False
Accurate, relevant, and timely information is the key to ____.
data management
good decision making
knowledge
understanding -Correct Answer ✔good decision making
True or False. One advantage of a database system over previous data management
approaches is that the database system is considerably less complex. -Correct Answer
✔False
The ____ model uses the concept of inheritance.
relational
network
object-oriented
entity relationship -Correct Answer ✔object-oriented
True or False. A manager and a programmer usually have the same view of the same
data. -Correct Answer ✔False
The ____ model uses the term connectivity to label the relationship types.
relational
network
IS 301- MIDTERM EXAM
IS 301- MIDTERM EXAM QUESTIONS
AND ANSWERS 2025 GRADED A
True or False. Database programming languages receive all application requests and
translate them into the complex operations required to fulfill those requests. -Correct
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 -Correct 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 -Correct Answer ✔query result set
True or False. One disadvantage of a database system over previous data
management approaches is increased costs. -Correct Answer ✔True
____ exists when different versions of the same data appear in different places.
Data inconsistency
Data consistency
Better data integration
Improved decision making -Correct Answer ✔Data inconsistency
True or False. A query language is a procedural language. -Correct Answer ✔False
True or False. Data processing can be as simple as organizing data to reveal patterns. -
Correct Answer ✔True
A(n) ____ database is used by an organization and supports many users across many
departments.
desktop
workgroup
enterprise
transactional -Correct Answer ✔enterprise
True or False. A data warehouse can store data derived from many sources. -Correct
Answer ✔True
IS 301- MIDTERM EXAM
, IS 301- MIDTERM EXAM
A ____ database supports data distributed across several different sites.
single-user
multiuser
centralized
distributed -Correct Answer ✔distributed
Which of the following is NOT part of the acronym CRUD?
Create
Relate
Update
Delete -Correct 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 -Correct Answer ✔normalization
True or False. Information implies familiarity, awareness, and understanding knowledge
as it applies to an environment. -Correct Answer ✔False
Accurate, relevant, and timely information is the key to ____.
data management
good decision making
knowledge
understanding -Correct Answer ✔good decision making
True or False. One advantage of a database system over previous data management
approaches is that the database system is considerably less complex. -Correct Answer
✔False
The ____ model uses the concept of inheritance.
relational
network
object-oriented
entity relationship -Correct Answer ✔object-oriented
True or False. A manager and a programmer usually have the same view of the same
data. -Correct Answer ✔False
The ____ model uses the term connectivity to label the relationship types.
relational
network
IS 301- MIDTERM EXAM
