← All topics
Quiz: Functional Dependencies: questions with answers
15 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. R(A, B, C, D) with F = {A → B, B → C, C → D}. What is A⁺?
- Q2. With the same F = {A → B, B → C, C → D}, what is C⁺?
- Q3. Which of these is a trivial functional dependency?
- Q4. A → BC holds. Which rule lets you conclude A → B?
- Q5. AB⁺ contains all attributes and A⁺ also contains all attributes. What is AB?
- Q6. An attribute appears on no right-hand side of any FD. What can you say about it?
- Q7. R(A, B, C) is split into R1(A, B) and R2(B, C). Which FD makes the split lossless?
- Q8. What are spurious tuples?
- Q9. F = {A → B, B → C, A → C}. Which FD is redundant?
- Q10. Which statement about BCNF and 3NF decomposition is true?
- Q11. R(A, B, C, D) with F = {AB → C, C → D, D → A}. What is C⁺?
- Q12. For the same R(A, B, C, D) and F = {AB → C, C → D, D → A}, which attribute must be in every candidate key?
- Q13. For the same F = {AB → C, C → D, D → A}, how many candidate keys does R(A, B, C, D) have?
- Q14. A → B and A → C hold. Which rule gives A → BC?
- Q15. A → B and CB → D hold. Which FD follows by pseudo-transitivity?