Free Test Functional Dependencie... – Databas...

Q1: What is a functional dependency?

A. A relationship where one attribute uniquely determines another B. A relationship between two tables C. A type of key D. No relationship exists

Q2: Which of the following is NOT a normal form?

A. 4NF B. 1NF C. 3NF D. 5NF

Q3: What is the main requirement of First Normal Form (1NF)?

A. Atomicity of attribute values and no repeating groups B. No partial dependency C. No transitive dependency D. Every determinant is a candidate key

Q4: What does Second Normal Form (2NF) eliminate?

A. Partial dependencies on part of a composite key B. Transitive dependencies C. Multivalued dependencies D. Redundant rows

Q5: Third Normal Form (3NF) requires elimination of?

A. Transitive dependencies B. Partial dependencies C. Multivalued dependencies D. Redundant keys

Q6: What is Boyce-Codd Normal Form (BCNF)?

A. Every determinant is a candidate key B. No partial dependency C. No transitive dependency D. Elimination of multivalued dependencies

Q7: What is a determinant in functional dependency?

A. An attribute on the left side that determines another attribute B. The dependent attribute C. A candidate key D. Foreign key

Q8: What kind of dependency does 2NF remove?

A. Partial dependency B. Transitive dependency C. Multivalued dependency D. No dependency

Q9: Which normal form addresses anomalies caused by transitive dependencies?

A. 3NF B. 1NF C. 2NF D. BCNF

Q10: What is a transitive dependency?

A. If A → B and B → C, then A → C B. If A → B and B → C, then B → A C. Dependency on candidate keys D. Dependency on foreign keys

Q11: What is a partial dependency?

A. An attribute depends on part of a composite key B. An attribute depends on all parts of the key C. A dependency with multiple attributes D. A dependency with no keys

Q12: Which normal form is stricter: BCNF or 3NF?

A. BCNF B. 3NF C. Both are same D. None of the above

Q13: When does a relation violate BCNF?

A. When a determinant is not a candidate key B. When there are transitive dependencies C. When there are partial dependencies D. When the key is composite

Q14: Which of the following is TRUE about 1NF?

A. No multi-valued attributes allowed B. No transitive dependencies C. No partial dependencies D. Every determinant is candidate key

Q15: Which normal form is focused on eliminating redundancy?

A. 3NF B. 1NF C. 2NF D. None

Q16: What happens if a relation is not in 2NF?

A. It may have partial dependency and redundancy B. It has transitive dependency C. It has no key D. It has multi-valued dependencies

Q17: Which of these is a consequence of transitive dependency?

A. Update anomaly B. Insertion anomaly C. Deletion anomaly D. No anomalies

Q18: Which of the following is NOT true?

A. BCNF handles all anomalies that 3NF does B. All relations in BCNF are also in 3NF C. All relations in 3NF are in BCNF D. BCNF is stricter than 3NF

Q19: What does closure of a set of functional dependencies help determine?

A. All attributes functionally determined B. Primary keys only C. Candidate keys only D. Foreign keys only

Quiz for Functional Dependencies and Normal Forms (1NF, 2NF, 3NF, BCNF)