21.) Which type of dependency exists when a non-prime attribute depends on another non-prime attribute?
A) Partial dependency
B) Transitive dependency
C) Multivalued dependency
D) Circular dependency
22.) What is the result of normalization up to BCNF?
A) Completely eliminates redundancy
B) Optimizes performance for all queries
C) Ensures every determinant is a candidate key
D) Allows multivalued attributes
23.) Why are foreign keys important in database design?
A) They reduce redundancy
B) They enforce referential integrity
C) They improve query performance
D) They act as composite keys
24.) Which normal form deals with multivalued dependencies?
A) 2NF
B) 3NF
C) 4NF
D) BCNF
25.) What is the main drawback of normalization?
A) Increases redundancy
B) Slower write operations due to more joins
C) Reduces data integrity
D) Reduces database size
26.) In database design, what does “schema” refer to?
A) A graphical representation of data
B) A database backup method
C) A query optimization technique
D) The structure of a database, including tables and relationships
Related
