1. Which of the following is a primary characteristic of a relational database?
A. Data is stored in tables, which are related to each other.
B. Data is stored in files.
C. Data is stored in objects.
D. Data is stored in nodes.
Answer: A
Rationale: A relational database stores data in tables, with relationships between those tables
defined by keys. Each table consists of rows and columns, and data is organized in a way that
facilitates easy retrieval and manipulation.
2. What does normalization in database design aim to achieve?
A. Minimize redundancy and avoid undesirable characteristics like update anomalies.
B. Maximize the size of the database.
C. Make the database faster to access.
D. Allow data to be stored in a single table.
Answer: A
Rationale: Normalization is the process of organizing data to minimize redundancy and
dependency, which helps avoid update anomalies and ensures data integrity.
,3. In the context of entity-relationship (ER) modeling, an entity is represented by:
A. A rectangle.
B. An oval.
C. A diamond.
D. A hexagon.
Answer: A
Rationale: In ER modeling, entities are represented by rectangles, which symbolize the objects or
things in the real world that are of interest to the database.
4. Which normal form eliminates transitive dependencies?
A. First normal form (1NF)
B. Second normal form (2NF)
C. Third normal form (3NF)
D. Boyce-Codd normal form (BCNF)
Answer: C
Rationale: The third normal form (3NF) eliminates transitive dependencies, which occur when a
non-key attribute depends on another non-key attribute.
5. What is the purpose of the primary key in a database table?
A. To provide a unique identifier for each row in the table.
B. To store foreign key references to other tables.
, C. To store large amounts of data.
D. To improve the speed of queries.
Answer: A
Rationale: The primary key uniquely identifies each row in a table. It ensures that no two rows in
a table have the same value for the primary key field.
6. Which of the following is a foreign key used for?
A. To uniquely identify rows in a table.
B. To create a relationship between two tables.
C. To store large binary objects.
D. To allow faster indexing of data.
Answer: B
Rationale: A foreign key is used to establish and enforce a link between the columns in two
different tables. It ensures referential integrity by linking a column in one table to a primary key
in another.
7. Which of the following is not a type of database relationship?
A. One-to-many
B. Many-to-many
C. One-to-one
D. One-to-join
A. Data is stored in tables, which are related to each other.
B. Data is stored in files.
C. Data is stored in objects.
D. Data is stored in nodes.
Answer: A
Rationale: A relational database stores data in tables, with relationships between those tables
defined by keys. Each table consists of rows and columns, and data is organized in a way that
facilitates easy retrieval and manipulation.
2. What does normalization in database design aim to achieve?
A. Minimize redundancy and avoid undesirable characteristics like update anomalies.
B. Maximize the size of the database.
C. Make the database faster to access.
D. Allow data to be stored in a single table.
Answer: A
Rationale: Normalization is the process of organizing data to minimize redundancy and
dependency, which helps avoid update anomalies and ensures data integrity.
,3. In the context of entity-relationship (ER) modeling, an entity is represented by:
A. A rectangle.
B. An oval.
C. A diamond.
D. A hexagon.
Answer: A
Rationale: In ER modeling, entities are represented by rectangles, which symbolize the objects or
things in the real world that are of interest to the database.
4. Which normal form eliminates transitive dependencies?
A. First normal form (1NF)
B. Second normal form (2NF)
C. Third normal form (3NF)
D. Boyce-Codd normal form (BCNF)
Answer: C
Rationale: The third normal form (3NF) eliminates transitive dependencies, which occur when a
non-key attribute depends on another non-key attribute.
5. What is the purpose of the primary key in a database table?
A. To provide a unique identifier for each row in the table.
B. To store foreign key references to other tables.
, C. To store large amounts of data.
D. To improve the speed of queries.
Answer: A
Rationale: The primary key uniquely identifies each row in a table. It ensures that no two rows in
a table have the same value for the primary key field.
6. Which of the following is a foreign key used for?
A. To uniquely identify rows in a table.
B. To create a relationship between two tables.
C. To store large binary objects.
D. To allow faster indexing of data.
Answer: B
Rationale: A foreign key is used to establish and enforce a link between the columns in two
different tables. It ensures referential integrity by linking a column in one table to a primary key
in another.
7. Which of the following is not a type of database relationship?
A. One-to-many
B. Many-to-many
C. One-to-one
D. One-to-join
