IS 301- MIDTERM EXAM Questions And
Correct Answers/ Latest Update / Already
Graded
True or False. Database programming languages receive all
application requests and translate them into the complex operations
required to fulfill those requests.
Ans: 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
Ans: Performance Tuning
,2 | Page
The response of the DBMS to a query is the ____.
ad hoc query
ad hoc response
query result set
integrated view of the data
Ans: query result set
True or False. One disadvantage of a database system over previous
data management approaches is increased costs.
Ans: True
____ exists when different versions of the same data appear in
different places.
Data inconsistency
Data consistency
,3 | Page
Better data integration
Improved decision making
Ans: Data inconsistency
True or False. A query language is a procedural language.
Ans: False
True or False. Data processing can be as simple as organizing data
to reveal patterns.
Ans: True
A(n) ____ database is used by an organization and supports many
users across many departments.
desktop
workgroup
, 4 | Page
enterprise
transactional
Ans: enterprise
True or False. A data warehouse can store data derived from many
sources.
Ans: True
A ____ database supports data distributed across several different
sites.
single-user
multiuser
centralized
distributed
Ans: distributed