D426 ITEC 2116
Data Management Foundations
Final Assessment (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question before
ANSing.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANSs. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANSs before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which of the following is a key feature of a relational
database?
- A. Hierarchical data structure
- B. Network data structure
- C. Table-based data structure
- D. Object-oriented data structure
- ANS: C
2. What is the primary purpose of normalization in database
design?
- A. To increase redundancy
- B. To reduce redundancy
- C. To increase data retrieval speed
- D. To create complex queries
- ANS: B
3. Which SQL command is used to remove a table from a
database?
- A. DELETE
- B. DROP
©2024/2025
, - C. REMOVE
- D. TRUNCATE
- ANS: B
4. In a database, what does ACID stand for?
- A. Atomicity, Consistency, Isolation, Durability
- B. Accuracy, Consistency, Integrity, Durability
- C. Atomicity, Consistency, Integrity, Durability
- D. Accuracy, Consistency, Isolation, Durability
- ANS: A
5. Which of the following is a NoSQL database?
- A. MySQL
- B. PostgreSQL
- C. MongoDB
- D. Oracle
- ANS: C
### Fill-in-the-Blank Questions
©2024/2025
, 6. The process of ensuring that a database remains in a consistent
state despite system failures is known as __________.
- ANS: Transaction Management
7. A __________ is a unique identifier for a record in a table.
- ANS: Primary Key
8. __________ is the process of organizing data to minimize
redundancy.
- ANS: Normalization
9. In SQL, the __________ clause is used to filter records.
- ANS: WHERE
10. A __________ is a collection of related data stored in a
structured format.
- ANS: Database
### True/False Questions
11. A foreign key is a field in a table that uniquely identifies a
row in another table.
- ANS: True
©2024/2025
Data Management Foundations
Final Assessment (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question before
ANSing.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANSs. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANSs before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which of the following is a key feature of a relational
database?
- A. Hierarchical data structure
- B. Network data structure
- C. Table-based data structure
- D. Object-oriented data structure
- ANS: C
2. What is the primary purpose of normalization in database
design?
- A. To increase redundancy
- B. To reduce redundancy
- C. To increase data retrieval speed
- D. To create complex queries
- ANS: B
3. Which SQL command is used to remove a table from a
database?
- A. DELETE
- B. DROP
©2024/2025
, - C. REMOVE
- D. TRUNCATE
- ANS: B
4. In a database, what does ACID stand for?
- A. Atomicity, Consistency, Isolation, Durability
- B. Accuracy, Consistency, Integrity, Durability
- C. Atomicity, Consistency, Integrity, Durability
- D. Accuracy, Consistency, Isolation, Durability
- ANS: A
5. Which of the following is a NoSQL database?
- A. MySQL
- B. PostgreSQL
- C. MongoDB
- D. Oracle
- ANS: C
### Fill-in-the-Blank Questions
©2024/2025
, 6. The process of ensuring that a database remains in a consistent
state despite system failures is known as __________.
- ANS: Transaction Management
7. A __________ is a unique identifier for a record in a table.
- ANS: Primary Key
8. __________ is the process of organizing data to minimize
redundancy.
- ANS: Normalization
9. In SQL, the __________ clause is used to filter records.
- ANS: WHERE
10. A __________ is a collection of related data stored in a
structured format.
- ANS: Database
### True/False Questions
11. A foreign key is a field in a table that uniquely identifies a
row in another table.
- ANS: True
©2024/2025
