1. What type of relationship is represented by a many-to-many relationship in a relational
database?
A. Direct relationship between two tables
B. Indirect relationship through a junction table
C. Single relationship with multiple values
D. No relationship exists
Answer: B) Indirect relationship through a junction table
Rationale: A many-to-many relationship is usually implemented by creating a junction table that
contains foreign keys referencing the related tables.
2. Which of the following is an example of a relational DBMS?
A. MongoDB
B. MySQL
C. Cassandra
D. Redis
Answer: B) MySQL
Rationale: MySQL is a relational DBMS, which uses tables to store data and supports SQL for
querying.
,3. What is an index in a database?
A. A data structure that improves query performance
B. A field used to uniquely identify records
C. A type of foreign key
D. A method for sorting data
Answer: A) A data structure that improves query performance
Rationale: An index is used to speed up the retrieval of rows from a table by providing a fast
lookup for certain columns.
4. In SQL, which command is used to remove a table from a database?
A. DELETE
B. DROP
C. REMOVE
D. TRUNCATE
Answer: B) DROP
Rationale: The DROP command is used to delete a table and its structure from a database.
5. Which SQL command is used to update data in a table?
A. INSERT
B. UPDATE
C. DELETE
, D. SELECT
Answer: B) UPDATE
Rationale: The UPDATE command is used to modify existing records in a table.
6. What does ACID stand for in database systems?
A. Atomicity, Consistency, Isolation, Durability
B. Accuracy, Consistency, Integrity, Durability
C. Analysis, Consistency, Isolation, Durability
D. Atomicity, Consistency, Integrity, Durability
Answer: A) Atomicity, Consistency, Isolation, Durability
Rationale: ACID is a set of properties that guarantee database transactions are processed reliably.
7. Which SQL command is used to delete all rows from a table without removing the table
structure?
A. DROP
B. DELETE
C. REMOVE
D. TRUNCATE
Answer: D) TRUNCATE
Rationale: TRUNCATE removes all rows from a table but leaves the table structure intact.
database?
A. Direct relationship between two tables
B. Indirect relationship through a junction table
C. Single relationship with multiple values
D. No relationship exists
Answer: B) Indirect relationship through a junction table
Rationale: A many-to-many relationship is usually implemented by creating a junction table that
contains foreign keys referencing the related tables.
2. Which of the following is an example of a relational DBMS?
A. MongoDB
B. MySQL
C. Cassandra
D. Redis
Answer: B) MySQL
Rationale: MySQL is a relational DBMS, which uses tables to store data and supports SQL for
querying.
,3. What is an index in a database?
A. A data structure that improves query performance
B. A field used to uniquely identify records
C. A type of foreign key
D. A method for sorting data
Answer: A) A data structure that improves query performance
Rationale: An index is used to speed up the retrieval of rows from a table by providing a fast
lookup for certain columns.
4. In SQL, which command is used to remove a table from a database?
A. DELETE
B. DROP
C. REMOVE
D. TRUNCATE
Answer: B) DROP
Rationale: The DROP command is used to delete a table and its structure from a database.
5. Which SQL command is used to update data in a table?
A. INSERT
B. UPDATE
C. DELETE
, D. SELECT
Answer: B) UPDATE
Rationale: The UPDATE command is used to modify existing records in a table.
6. What does ACID stand for in database systems?
A. Atomicity, Consistency, Isolation, Durability
B. Accuracy, Consistency, Integrity, Durability
C. Analysis, Consistency, Isolation, Durability
D. Atomicity, Consistency, Integrity, Durability
Answer: A) Atomicity, Consistency, Isolation, Durability
Rationale: ACID is a set of properties that guarantee database transactions are processed reliably.
7. Which SQL command is used to delete all rows from a table without removing the table
structure?
A. DROP
B. DELETE
C. REMOVE
D. TRUNCATE
Answer: D) TRUNCATE
Rationale: TRUNCATE removes all rows from a table but leaves the table structure intact.
