🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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 →
  1. Q1. R(A, B, C, D) with F = {A → B, B → C, C → D}. What is A⁺?
  2. Q2. With the same F = {A → B, B → C, C → D}, what is C⁺?
  3. Q3. Which of these is a trivial functional dependency?
  4. Q4. A → BC holds. Which rule lets you conclude A → B?
  5. Q5. AB⁺ contains all attributes and A⁺ also contains all attributes. What is AB?
  6. Q6. An attribute appears on no right-hand side of any FD. What can you say about it?
  7. Q7. R(A, B, C) is split into R1(A, B) and R2(B, C). Which FD makes the split lossless?
  8. Q8. What are spurious tuples?
  9. Q9. F = {A → B, B → C, A → C}. Which FD is redundant?
  10. Q10. Which statement about BCNF and 3NF decomposition is true?
  11. Q11. R(A, B, C, D) with F = {AB → C, C → D, D → A}. What is C⁺?
  12. 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?
  13. Q13. For the same F = {AB → C, C → D, D → A}, how many candidate keys does R(A, B, C, D) have?
  14. Q14. A → B and A → C hold. Which rule gives A → BC?
  15. Q15. A → B and CB → D hold. Which FD follows by pseudo-transitivity?