IS 183
Database Concepts & Applications I
LATEST MIDTERMS REVIEW
Q&S
©2024/2025
,1. Multiple Choice: Which of the following is not a core feature
of Database as a Service (DBaaS)?
a) Automated backup
b) Data replication
c) Manual scaling
d) Integrated caching
Answer: c) Manual scaling
Rationale: DBaaS typically provides automated scaling
capabilities rather than manual scaling, which allows for better
resource management and cost efficiency.
2. Fill-in-the-Blank: In a relational database, the relationship
between two tables is established through a __________ key.
Answer: Foreign
Rationale: A foreign key is used to link two tables together,
which is a fundamental aspect of relational database design and
ensures referential integrity.
3. True/False: Entity Relationship Diagrams (ERDs) are essential
in the normalization process of database design.
Answer: True
©2024/2025
, Rationale: ERDs help in visualizing the structure of the
database, which is crucial for normalizing the database and
reducing redundancy.
4. Multiple Response: Select all that apply. Ensuring data
integrity involves:
a) Enforcing data type constraints
b) Implementing business rules
c) Regularly updating data
d) Maintaining database backups
Answers: a) Enforcing data type constraints, b) Implementing
business rules
Rationale: Data integrity is maintained by enforcing data types
and business rules, whereas updating data and maintaining
backups are related to data currency and recovery, respectively.
5. Multiple Choice: In SQL, the 'HAVING' clause is used in
conjunction with:
a) SELECT
b) WHERE
c) GROUP BY
d) ORDER BY
Answer: c) GROUP BY
©2024/2025
Database Concepts & Applications I
LATEST MIDTERMS REVIEW
Q&S
©2024/2025
,1. Multiple Choice: Which of the following is not a core feature
of Database as a Service (DBaaS)?
a) Automated backup
b) Data replication
c) Manual scaling
d) Integrated caching
Answer: c) Manual scaling
Rationale: DBaaS typically provides automated scaling
capabilities rather than manual scaling, which allows for better
resource management and cost efficiency.
2. Fill-in-the-Blank: In a relational database, the relationship
between two tables is established through a __________ key.
Answer: Foreign
Rationale: A foreign key is used to link two tables together,
which is a fundamental aspect of relational database design and
ensures referential integrity.
3. True/False: Entity Relationship Diagrams (ERDs) are essential
in the normalization process of database design.
Answer: True
©2024/2025
, Rationale: ERDs help in visualizing the structure of the
database, which is crucial for normalizing the database and
reducing redundancy.
4. Multiple Response: Select all that apply. Ensuring data
integrity involves:
a) Enforcing data type constraints
b) Implementing business rules
c) Regularly updating data
d) Maintaining database backups
Answers: a) Enforcing data type constraints, b) Implementing
business rules
Rationale: Data integrity is maintained by enforcing data types
and business rules, whereas updating data and maintaining
backups are related to data currency and recovery, respectively.
5. Multiple Choice: In SQL, the 'HAVING' clause is used in
conjunction with:
a) SELECT
b) WHERE
c) GROUP BY
d) ORDER BY
Answer: c) GROUP BY
©2024/2025
