1. Which of the following is a logical model in database design?
A. Relational model
B. Physical model
C. Columnar model
D. File system model
Answer: A
Rationale: The relational model is a logical model in database design, where data is
stored in tables and manipulated using SQL.
2. A stored procedure in SQL is:
A. A precompiled set of SQL statements that can be executed.
B. A temporary table used to store query results.
C. A method for normalizing data.
D. A database function that returns a value.
Answer: A
,Rationale: A stored procedure is a precompiled set of SQL statements that can be
executed repeatedly, which helps with code reuse and performance optimization.
3. 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.
4. What is the purpose of a transaction in a database system?
A. To ensure the database is backed up.
B. To maintain the integrity of a series of operations.
C. To create a new database table.
D. To optimize data storage.
Answer: B
, Rationale: A transaction ensures that a series of database operations are executed
as a single unit. It follows the ACID properties (Atomicity, Consistency, Isolation,
Durability) to maintain database integrity.
5. 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.
6. In a many-to-many relationship, which of the following is typically required?
A. A composite primary key.
B. A foreign key.
C. A junction table.
D. A view.
A. Relational model
B. Physical model
C. Columnar model
D. File system model
Answer: A
Rationale: The relational model is a logical model in database design, where data is
stored in tables and manipulated using SQL.
2. A stored procedure in SQL is:
A. A precompiled set of SQL statements that can be executed.
B. A temporary table used to store query results.
C. A method for normalizing data.
D. A database function that returns a value.
Answer: A
,Rationale: A stored procedure is a precompiled set of SQL statements that can be
executed repeatedly, which helps with code reuse and performance optimization.
3. 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.
4. What is the purpose of a transaction in a database system?
A. To ensure the database is backed up.
B. To maintain the integrity of a series of operations.
C. To create a new database table.
D. To optimize data storage.
Answer: B
, Rationale: A transaction ensures that a series of database operations are executed
as a single unit. It follows the ACID properties (Atomicity, Consistency, Isolation,
Durability) to maintain database integrity.
5. 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.
6. In a many-to-many relationship, which of the following is typically required?
A. A composite primary key.
B. A foreign key.
C. A junction table.
D. A view.
