1. Which of the following is true about a composite key?
A. It is a single field that uniquely identifies a record
B. It consists of two or more fields that together uniquely identify a record
C. It is used to join tables
D. It cannot be null
Answer: B) It consists of two or more fields that together uniquely identify a
record
Rationale: A composite key is made up of two or more columns in a table to
uniquely identify a record.
2. Which of the following is a benefit of using database replication?
A. It decreases data consistency
B. It improves query performance and availability
C. It limits data accessibility to a single server
D. It reduces the need for backups
Answer: B) It improves query performance and availability
,Rationale: Database replication increases data availability and can improve query
performance by creating copies of the data across multiple locations.
3. What is the purpose of the GROUP BY clause in SQL?
A. To order the results of a query
B. To filter rows based on conditions
C. To combine multiple rows into a single summary row
D. To limit the number of rows returned
Answer: C) To combine multiple rows into a single summary row
Rationale: GROUP BY is used to group rows that have the same values in
specified columns into summary rows, often used with aggregate functions like
COUNT, SUM, or AVG.
4. Which of the following is a type of database relationship?
A. Parent-Child
B. One-to-Many
C. One-to-One
D. All of the above
, Answer: D) All of the above
Rationale: Databases can have different types of relationships, including one-to-
one, one-to-many, and many-to-many relationships, to link tables.
5. 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.
6. 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
A. It is a single field that uniquely identifies a record
B. It consists of two or more fields that together uniquely identify a record
C. It is used to join tables
D. It cannot be null
Answer: B) It consists of two or more fields that together uniquely identify a
record
Rationale: A composite key is made up of two or more columns in a table to
uniquely identify a record.
2. Which of the following is a benefit of using database replication?
A. It decreases data consistency
B. It improves query performance and availability
C. It limits data accessibility to a single server
D. It reduces the need for backups
Answer: B) It improves query performance and availability
,Rationale: Database replication increases data availability and can improve query
performance by creating copies of the data across multiple locations.
3. What is the purpose of the GROUP BY clause in SQL?
A. To order the results of a query
B. To filter rows based on conditions
C. To combine multiple rows into a single summary row
D. To limit the number of rows returned
Answer: C) To combine multiple rows into a single summary row
Rationale: GROUP BY is used to group rows that have the same values in
specified columns into summary rows, often used with aggregate functions like
COUNT, SUM, or AVG.
4. Which of the following is a type of database relationship?
A. Parent-Child
B. One-to-Many
C. One-to-One
D. All of the above
, Answer: D) All of the above
Rationale: Databases can have different types of relationships, including one-to-
one, one-to-many, and many-to-many relationships, to link tables.
5. 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.
6. 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
