16. Which SQL function is used to find the maximum value in a column?
A) MIN()
B) AVG()
C) COUNT()
D) MAX()
Answer: D
17. Which normal form allows multivalued dependencies to be eliminated?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Fourth Normal Form (4NF)
Answer: D
18. In a database, a one-to-many relationship is represented using:
A) One table only
B) Two tables and a link table
C) Two tables and a foreign key
D) Three tables and a primary key
Answer: C
19. Which SQL statement is used to delete data from a database table?
A) DELETE
B) DROP
C) TRUNCATE
D) REMOVE
Answer: A
20. The process of combining tables to produce a result set from multiple queries is known as:
A) Subquery
B) Union
C) Join
D) Merge
Answer: C
