1. Which of the following is the primary function of a Database Management
System (DBMS)?
A. To provide user interface
B. To store and manage data
C. To design user interfaces
D. To handle server configurations
Answer: B) To store and manage data
Rationale: The main role of a DBMS is to store, manage, and organize data
efficiently, ensuring data integrity and security.
2. What is the purpose of normalization in database design?
A. To reduce data redundancy and improve data integrity
B. To make queries run faster
C. To create multiple copies of the data
D. To store data in a denormalized form
Answer: A) To reduce data redundancy and improve data integrity
,Rationale: Normalization helps in organizing data to minimize redundancy and
dependencies, thereby improving the integrity of the database.
3. In the context of databases, what does ACID stand for?
A. Accuracy, Consistency, Integrity, Durability
B. Atomicity, Consistency, Isolation, Durability
C. Automation, Configuration, Isolation, Durability
D. Application, Consistency, Integrity, Durability
Answer: B) Atomicity, Consistency, Isolation, Durability
Rationale: ACID is a set of properties ensuring that database transactions are
processed reliably, which includes atomicity, consistency, isolation, and durability.
4. Which SQL clause is used to filter records based on specific conditions?
A. ORDER BY
B. SELECT
C. WHERE
D. JOIN
Answer: C) WHERE
, Rationale: The WHERE clause is used to filter records that meet a certain
condition.
5. What is the primary purpose of an Entity-Relationship Diagram (ERD)?
A. To define the data types of fields in a database
B. To visually represent the structure of a database and relationships between
entities
C. To generate SQL queries
D. To store database configuration settings
Answer: B) To visually represent the structure of a database and relationships
between entities
Rationale: ERDs help to model the logical structure of a database, showing
entities, attributes, and the relationships between them.
6. Which of the following is a type of database relationship?
A. Parent-Child
B. One-to-Many
C. One-to-One
System (DBMS)?
A. To provide user interface
B. To store and manage data
C. To design user interfaces
D. To handle server configurations
Answer: B) To store and manage data
Rationale: The main role of a DBMS is to store, manage, and organize data
efficiently, ensuring data integrity and security.
2. What is the purpose of normalization in database design?
A. To reduce data redundancy and improve data integrity
B. To make queries run faster
C. To create multiple copies of the data
D. To store data in a denormalized form
Answer: A) To reduce data redundancy and improve data integrity
,Rationale: Normalization helps in organizing data to minimize redundancy and
dependencies, thereby improving the integrity of the database.
3. In the context of databases, what does ACID stand for?
A. Accuracy, Consistency, Integrity, Durability
B. Atomicity, Consistency, Isolation, Durability
C. Automation, Configuration, Isolation, Durability
D. Application, Consistency, Integrity, Durability
Answer: B) Atomicity, Consistency, Isolation, Durability
Rationale: ACID is a set of properties ensuring that database transactions are
processed reliably, which includes atomicity, consistency, isolation, and durability.
4. Which SQL clause is used to filter records based on specific conditions?
A. ORDER BY
B. SELECT
C. WHERE
D. JOIN
Answer: C) WHERE
, Rationale: The WHERE clause is used to filter records that meet a certain
condition.
5. What is the primary purpose of an Entity-Relationship Diagram (ERD)?
A. To define the data types of fields in a database
B. To visually represent the structure of a database and relationships between
entities
C. To generate SQL queries
D. To store database configuration settings
Answer: B) To visually represent the structure of a database and relationships
between entities
Rationale: ERDs help to model the logical structure of a database, showing
entities, attributes, and the relationships between them.
6. Which of the following is a type of database relationship?
A. Parent-Child
B. One-to-Many
C. One-to-One
