🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← All topics

Quiz: 4NF and 5NF: questions with answers

10 questions, each with the answer and a short explanation.

Take the timed quiz + get a certificate →
  1. Q1. Table R(teacher, subject, language) has teacher ↠ subject and teacher ↠ language, and its only key is all three columns. Which is true?
  2. Q2. In R(A, B, C), which multivalued dependency is trivial?
  3. Q3. Which statement is correct?
  4. Q4. Rows (Asha, DBMS, Hindi) and (Asha, OS, English) exist and teacher ↠ subject holds. Which row must also exist?
  5. Q5. How should R(teacher, subject, language) with teacher ↠ subject be decomposed into 4NF?
  6. Q6. What does this print? (code)
  7. Q7. What is a join dependency?
  8. Q8. What is another name for 5NF?
  9. Q9. In the agent–company–product example, why is joining only agentcompany and companyproduct not enough?
  10. Q10. Which ordering of normal forms from least strict to most strict is correct?