11. Which normal form ensures that there are no partial dependencies in a database table?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)
Answer: C
12. Which SQL clause is used to specify conditions in a SELECT statement?
A) WHERE
B) HAVING
C) GROUP BY
D) ORDER BY
Answer: A
13. Which type of index uses a balanced tree data structure?
A) Clustered index
B) Bitmap index
C) B-tree index
D) Hash index
Answer: C
14. In a relational database, a foreign key is used to:
A) Create a relationship between two tables
B) Speed up data retrieval
C) Ensure data integrity
D) Define the data types for attributes
Answer: A
15. The process of reverting a database to a previous state is called:
A) Rollback
B) Commit
C) Locking
D) Cloning
Answer: A
