1. The many-to-one relationship in a database means:
A. Many records in one table can correspond to one record in another table.
B. One record in a table corresponds to many records in another table.
C. A record in one table corresponds to a unique record in another table.
D. One record in a table corresponds to no records in another table.
Answer: A
Rationale: A many-to-one relationship means that many records in one table can
correspond to a single record in another table.
2. A relation in a relational database is equivalent to:
A. A table.
B. A row.
C. A column.
D. A query.
Answer: A
,Rationale: In relational databases, a relation refers to a table, where data is
organized into rows and columns.
3. The conceptual schema in database design is:
A. A detailed design of the database at the storage level.
B. A high-level representation of the database, focusing on the structure.
C. A specification of user interfaces.
D. A method to display data from the database.
Answer: B
Rationale: The conceptual schema represents the logical structure of the database,
focusing on what data is stored and the relationships between data without
considering physical storage.
4. 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.
5. Which of the following is a constraint in a database?
A. Primary key
B. Data type
C. Foreign key
D. All of the above
Answer: D
Rationale: Primary keys, foreign keys, and data types are all types of constraints
that enforce data integrity rules within a database.
6. Which of the following is an example of data redundancy?
A. Storing the same data in multiple locations.
B. Using unique keys for each record.
C. Storing foreign key references between tables.
A. Many records in one table can correspond to one record in another table.
B. One record in a table corresponds to many records in another table.
C. A record in one table corresponds to a unique record in another table.
D. One record in a table corresponds to no records in another table.
Answer: A
Rationale: A many-to-one relationship means that many records in one table can
correspond to a single record in another table.
2. A relation in a relational database is equivalent to:
A. A table.
B. A row.
C. A column.
D. A query.
Answer: A
,Rationale: In relational databases, a relation refers to a table, where data is
organized into rows and columns.
3. The conceptual schema in database design is:
A. A detailed design of the database at the storage level.
B. A high-level representation of the database, focusing on the structure.
C. A specification of user interfaces.
D. A method to display data from the database.
Answer: B
Rationale: The conceptual schema represents the logical structure of the database,
focusing on what data is stored and the relationships between data without
considering physical storage.
4. 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.
5. Which of the following is a constraint in a database?
A. Primary key
B. Data type
C. Foreign key
D. All of the above
Answer: D
Rationale: Primary keys, foreign keys, and data types are all types of constraints
that enforce data integrity rules within a database.
6. Which of the following is an example of data redundancy?
A. Storing the same data in multiple locations.
B. Using unique keys for each record.
C. Storing foreign key references between tables.
