11.) What does the term “data anomaly” mean?
A) Normal data storage
B) Enhanced query speed
C) Issues caused by redundant data
D) Data security breaches
12.) Which normal form is achieved when every determinant is a candidate key?
A) BCNF
B) 3NF
C) 4NF
D) 5NF
13.) What is a composite key?
A) A foreign key with a single column
B) A primary key consisting of multiple columns
C) A key used for indexing
D) A temporary key
14.) What type of dependency does 3NF eliminate?
A) Partial dependency
B) Transitive dependency
C) Multivalued dependency
D) Circular dependency
15.) What is denormalization?
A) Combining tables to improve performance
B) Breaking tables into smaller parts
C) Eliminating all keys from a table
D) Normalizing a database to BCNF
16.) Which normal form is also known as 2NF with additional conditions?
A) BCNF
B) 3NF
C) 4NF
D) 5NF
17.) What is an anomaly in the context of databases?
A) A security issue
B) A query optimization technique
C) A high-performance operation
D) A redundancy issue causing inconsistencies
18.) What does the term “atomicity” refer to in normalization?
A) Data is stored in multiple columns
B) Each cell contains a single, indivisible value
C) Data is stored in one table
D) Data contains multivalued attributes
19.) What is the primary focus of the 5th Normal Form (5NF)?
A) Eliminating partial dependencies
B) Eliminating composite keys
C) Ensuring atomic columns
D) Removing join dependencies
20.) In a database table, what does “redundancy” mean?
A) Duplicate or repetitive data
B) Optimal storage utilization
C) Data integrity
D) Efficient indexing
Related
