,Chapter 01: Database Systems
1. Which of the following best explains data independence in a database system?
a. The ability to change data values without altering metadata.
b. The ability to change the physical storage of data without affecting logical access.
c. The ability to update data without changing data definitions.
d. The ability to access data from multiple programs concurrently.
Answer: b
Rationale:
Data independence refers to the separation between physical data storage and the logical data model. This allows
changes in storage structure without rewriting application programs — a key benefit of using a DBMS compared to
file systems.
2. Which component of a database system defines and stores relationships among data elements?
a. Data warehouse
b. Data dictionary
c. Query processor
d. Application interface
Answer: b
Rationale:
The data dictionary (metadata repository) stores structural information such as table definitions, constraints,
relationships, and access rights. It acts as the “database about the database.”
3. What problem does data redundancy most commonly cause in traditional file systems?
a. Data security improvement
b. Faster data retrieval
c. Data anomalies and inconsistency
d. Easier database design
Answer: c
Rationale:
When the same data appears in multiple files, inconsistent updates lead to data anomalies, compromising data
integrity and reliability.
Copyright Cengage Learning. Powered by Cognero. Page 1
,4. Which statement best distinguishes data from information?
a. Data is processed meaning; information is unprocessed facts.
b. Data and information are interchangeable.
c. Data are raw facts, while information is processed data that conveys meaning.
d. Data is meaningful only after encryption.
Answer: c
Rationale:
Data are raw, unprocessed facts; when these are organized or processed to reveal context and significance, they
become information.
5. Which of the following most accurately describes a database management system (DBMS)?
a. A file storage mechanism for unstructured data.
b. A collection of interrelated data and metadata.
c. A software suite that defines, stores, and manages data access.
d. A system designed only for analytical data processing.
Answer: c
Rationale:
A DBMS manages data structures, enforces rules, controls access, and provides tools for manipulation and
retrieval, ensuring data consistency and integrity.
6. In a file-based system, changing a data format often requires rewriting application code. This illustrates:
a. Data independence
b. Structural dependence
c. Data integrity
d. Data normalization
Answer: b
Rationale:
Structural dependence occurs when file structure changes affect application programs — a major drawback of
traditional file systems that DBMSs overcome.
7. Which of the following scenarios best describes data inconsistency?
a. Missing records in multiple files
b. Different values of the same data item stored in different places
c. Duplicate records within a single table
d. Unauthorized data access
Copyright Cengage Learning. Powered by Cognero. Page 2
, Answer: b
Rationale:
Data inconsistency occurs when multiple copies of the same data are not updated uniformly, resulting in
conflicting information across the system.
8. A collection of logically related records is referred to as a:
a. Field
b. File
c. Table
d. Schema
Answer: b
Rationale:
In file systems, multiple records (e.g., student records) grouped together form a file, the predecessor to modern
database tables.
9. Which type of database primarily supports decision-making processes using historical data?
a. Operational database
b. Analytical database
c. Distributed database
d. Cloud database
Answer: b
Rationale:
Analytical databases (e.g., data warehouses) focus on aggregating historical data for analysis, unlike operational
databases that support day-to-day transactions.
10. A DBMS performs performance tuning to:
a. Increase data redundancy
b. Simplify SQL syntax
c. Optimize data access speed and storage efficiency
d. Encrypt data during transmission
Answer: c
Rationale:
Performance tuning adjusts indexing, query optimization, and data structure organization to enhance access speed
and minimize storage overhead.
Copyright Cengage Learning. Powered by Cognero. Page 3
1. Which of the following best explains data independence in a database system?
a. The ability to change data values without altering metadata.
b. The ability to change the physical storage of data without affecting logical access.
c. The ability to update data without changing data definitions.
d. The ability to access data from multiple programs concurrently.
Answer: b
Rationale:
Data independence refers to the separation between physical data storage and the logical data model. This allows
changes in storage structure without rewriting application programs — a key benefit of using a DBMS compared to
file systems.
2. Which component of a database system defines and stores relationships among data elements?
a. Data warehouse
b. Data dictionary
c. Query processor
d. Application interface
Answer: b
Rationale:
The data dictionary (metadata repository) stores structural information such as table definitions, constraints,
relationships, and access rights. It acts as the “database about the database.”
3. What problem does data redundancy most commonly cause in traditional file systems?
a. Data security improvement
b. Faster data retrieval
c. Data anomalies and inconsistency
d. Easier database design
Answer: c
Rationale:
When the same data appears in multiple files, inconsistent updates lead to data anomalies, compromising data
integrity and reliability.
Copyright Cengage Learning. Powered by Cognero. Page 1
,4. Which statement best distinguishes data from information?
a. Data is processed meaning; information is unprocessed facts.
b. Data and information are interchangeable.
c. Data are raw facts, while information is processed data that conveys meaning.
d. Data is meaningful only after encryption.
Answer: c
Rationale:
Data are raw, unprocessed facts; when these are organized or processed to reveal context and significance, they
become information.
5. Which of the following most accurately describes a database management system (DBMS)?
a. A file storage mechanism for unstructured data.
b. A collection of interrelated data and metadata.
c. A software suite that defines, stores, and manages data access.
d. A system designed only for analytical data processing.
Answer: c
Rationale:
A DBMS manages data structures, enforces rules, controls access, and provides tools for manipulation and
retrieval, ensuring data consistency and integrity.
6. In a file-based system, changing a data format often requires rewriting application code. This illustrates:
a. Data independence
b. Structural dependence
c. Data integrity
d. Data normalization
Answer: b
Rationale:
Structural dependence occurs when file structure changes affect application programs — a major drawback of
traditional file systems that DBMSs overcome.
7. Which of the following scenarios best describes data inconsistency?
a. Missing records in multiple files
b. Different values of the same data item stored in different places
c. Duplicate records within a single table
d. Unauthorized data access
Copyright Cengage Learning. Powered by Cognero. Page 2
, Answer: b
Rationale:
Data inconsistency occurs when multiple copies of the same data are not updated uniformly, resulting in
conflicting information across the system.
8. A collection of logically related records is referred to as a:
a. Field
b. File
c. Table
d. Schema
Answer: b
Rationale:
In file systems, multiple records (e.g., student records) grouped together form a file, the predecessor to modern
database tables.
9. Which type of database primarily supports decision-making processes using historical data?
a. Operational database
b. Analytical database
c. Distributed database
d. Cloud database
Answer: b
Rationale:
Analytical databases (e.g., data warehouses) focus on aggregating historical data for analysis, unlike operational
databases that support day-to-day transactions.
10. A DBMS performs performance tuning to:
a. Increase data redundancy
b. Simplify SQL syntax
c. Optimize data access speed and storage efficiency
d. Encrypt data during transmission
Answer: c
Rationale:
Performance tuning adjusts indexing, query optimization, and data structure organization to enhance access speed
and minimize storage overhead.
Copyright Cengage Learning. Powered by Cognero. Page 3
