C175 DATA MANAGEMENT
FOUNDATIONS MIDTERM EXAM
QUESTIONS WITH VERIFIED ANSWERS
AND DETAILED EXPLANATIONS.
2026/2027
1. What is the primary difference between data and information?
A. Data is processed while information is raw facts.
B. Information is processed data that reveals meaning.
C. Data is stored in a database while information is stored in flat files.
D. There is no functional difference between the two terms.
Answer: B
Conceptual Explanation: Data consists of raw facts, while information is the result of
processing those facts to reveal patterns or meaning.
2. Which component of a database system is responsible for managing data storage, security,
and multi-user access?
A. The Query Processor
B. The Database Management System (DBMS)
,C. The Application Program
D. The Data Dictionary
Answer: B
Conceptual Explanation: The DBMS is the software that manages the database structures
and controls access to the data stored within it.
3. A ‘metadata’ description of a table would most likely include which of the following?
A. The actual names of all customers in the table.
B. A backup copy of the database records.
C. The data type and length of the ‘CustomerName’ column.
D. The SQL query used to delete a record.
Answer: C
Conceptual Explanation: Metadata is ‘data about data’, such as field names, data types,
and constraints.
4. What is ‘structural independence’ in a database environment?
A. The ability to change the hardware without moving the data.
B. The ability to change the database schema without affecting application programs.
C. The requirement that all tables have the same number of columns.
D. The ability to access data without knowing the physical storage location.
, Answer: B
Conceptual Explanation: Structural independence exists when you can change the file
structure without affecting the application’s ability to access the data.
5. In the context of data modeling, what is a ‘business rule’?
A. A technical specification for the server hardware.
B. A brief, precise, and unambiguous description of a policy or procedure within an
organization.
C. The legal contract between a database vendor and a client.
D. A set of SQL commands used to generate reports.
Answer: B
Conceptual Explanation: Business rules define the environment and relationships of data
from the perspective of the organization.
6. Which model represents the highest level of abstraction, focusing on the data’s nature
from a user’s perspective?
A. The Physical Model
B. The Conceptual Model
C. The Internal Model
D. The Relational Model
Answer: B
FOUNDATIONS MIDTERM EXAM
QUESTIONS WITH VERIFIED ANSWERS
AND DETAILED EXPLANATIONS.
2026/2027
1. What is the primary difference between data and information?
A. Data is processed while information is raw facts.
B. Information is processed data that reveals meaning.
C. Data is stored in a database while information is stored in flat files.
D. There is no functional difference between the two terms.
Answer: B
Conceptual Explanation: Data consists of raw facts, while information is the result of
processing those facts to reveal patterns or meaning.
2. Which component of a database system is responsible for managing data storage, security,
and multi-user access?
A. The Query Processor
B. The Database Management System (DBMS)
,C. The Application Program
D. The Data Dictionary
Answer: B
Conceptual Explanation: The DBMS is the software that manages the database structures
and controls access to the data stored within it.
3. A ‘metadata’ description of a table would most likely include which of the following?
A. The actual names of all customers in the table.
B. A backup copy of the database records.
C. The data type and length of the ‘CustomerName’ column.
D. The SQL query used to delete a record.
Answer: C
Conceptual Explanation: Metadata is ‘data about data’, such as field names, data types,
and constraints.
4. What is ‘structural independence’ in a database environment?
A. The ability to change the hardware without moving the data.
B. The ability to change the database schema without affecting application programs.
C. The requirement that all tables have the same number of columns.
D. The ability to access data without knowing the physical storage location.
, Answer: B
Conceptual Explanation: Structural independence exists when you can change the file
structure without affecting the application’s ability to access the data.
5. In the context of data modeling, what is a ‘business rule’?
A. A technical specification for the server hardware.
B. A brief, precise, and unambiguous description of a policy or procedure within an
organization.
C. The legal contract between a database vendor and a client.
D. A set of SQL commands used to generate reports.
Answer: B
Conceptual Explanation: Business rules define the environment and relationships of data
from the perspective of the organization.
6. Which model represents the highest level of abstraction, focusing on the data’s nature
from a user’s perspective?
A. The Physical Model
B. The Conceptual Model
C. The Internal Model
D. The Relational Model
Answer: B
