BIS245
Database Essentials for Business
Final Exam Review (Qns & Ans)
2025
Multiple Choice Questions
1. What is the primary purpose of normalization in database
design?
A. To increase data redundancy
B. To improve query execution time
C. To eliminate data redundancy and ensure data integrity
D. To encrypt database contents
©2025
, ANS: C. To eliminate data redundancy and ensure data
integrity
Rationale: Normalization reduces redundancy and organizes
data into logical structures, which enhances consistency.
2. Which SQL statement is used to retrieve specific columns
from a database table?
A. INSERT
B. SELECT
C. UPDATE
D. DELETE
ANS: B. SELECT
Rationale: The `SELECT` statement is used to query and
retrieve specific columns from a table.
3. In a relational database, what is a foreign key?
A. A unique identifier for each table row
B. A key that references the primary key in another table
C. A key that encrypts sensitive data
D. A duplicate key used for performance optimization
ANS: B. A key that references the primary key in another
table
©2025
, Rationale: Foreign keys create relationships between tables
and enforce referential integrity.
---
Fill-in-the-Blank Questions
4. The process of ensuring that data is stored without
unnecessary duplication is called _______.
ANS: Normalization
Rationale: Normalization reduces redundancy and organizes
data more efficiently.
5. An SQL query that groups rows with the same values and
allows aggregation is called a _______ clause.
ANS: GROUP BY
Rationale: The `GROUP BY` clause is used to group rows
and perform aggregate functions such as `COUNT()` or `SUM()`.
---
True/False Questions
©2025
, 6. True or False: A primary key in a database table must be
unique for each record.
ANS: True
Rationale: Primary keys uniquely identify records in a table,
ensuring no duplicates.
7. True or False: Data in a database can only be accessed
through SQL.
ANS: False
Rationale: While SQL is the standard query language, data
can also be accessed using APIs, database management tools, and
other programming languages.
---
Multiple Response Questions
8. Which of the following are valid database management
systems? (Select all that apply)
A. MySQL
B. MongoDB
©2025
Database Essentials for Business
Final Exam Review (Qns & Ans)
2025
Multiple Choice Questions
1. What is the primary purpose of normalization in database
design?
A. To increase data redundancy
B. To improve query execution time
C. To eliminate data redundancy and ensure data integrity
D. To encrypt database contents
©2025
, ANS: C. To eliminate data redundancy and ensure data
integrity
Rationale: Normalization reduces redundancy and organizes
data into logical structures, which enhances consistency.
2. Which SQL statement is used to retrieve specific columns
from a database table?
A. INSERT
B. SELECT
C. UPDATE
D. DELETE
ANS: B. SELECT
Rationale: The `SELECT` statement is used to query and
retrieve specific columns from a table.
3. In a relational database, what is a foreign key?
A. A unique identifier for each table row
B. A key that references the primary key in another table
C. A key that encrypts sensitive data
D. A duplicate key used for performance optimization
ANS: B. A key that references the primary key in another
table
©2025
, Rationale: Foreign keys create relationships between tables
and enforce referential integrity.
---
Fill-in-the-Blank Questions
4. The process of ensuring that data is stored without
unnecessary duplication is called _______.
ANS: Normalization
Rationale: Normalization reduces redundancy and organizes
data more efficiently.
5. An SQL query that groups rows with the same values and
allows aggregation is called a _______ clause.
ANS: GROUP BY
Rationale: The `GROUP BY` clause is used to group rows
and perform aggregate functions such as `COUNT()` or `SUM()`.
---
True/False Questions
©2025
, 6. True or False: A primary key in a database table must be
unique for each record.
ANS: True
Rationale: Primary keys uniquely identify records in a table,
ensuring no duplicates.
7. True or False: Data in a database can only be accessed
through SQL.
ANS: False
Rationale: While SQL is the standard query language, data
can also be accessed using APIs, database management tools, and
other programming languages.
---
Multiple Response Questions
8. Which of the following are valid database management
systems? (Select all that apply)
A. MySQL
B. MongoDB
©2025
