©FYNDLAY 2024/2025 ALL RIGHTS RESERVED 12:27AM. A+
IS 301- MIDTERM Exam Questions And
Answers| Already Graded A+| Latest Update.
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.
Data inconsistency
Data consistency
Better data integration
Improved decision making - Answer✔Data inconsistency
1
, ©FYNDLAY 2024/2025 ALL RIGHTS RESERVED 12:27AM. A+
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
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
2
IS 301- MIDTERM Exam Questions And
Answers| Already Graded A+| Latest Update.
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.
Data inconsistency
Data consistency
Better data integration
Improved decision making - Answer✔Data inconsistency
1
, ©FYNDLAY 2024/2025 ALL RIGHTS RESERVED 12:27AM. A+
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
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
2
