Normal Form MCQ - Quiz

  • A BCNF is stricter than 3 NF
  • B Lossless, dependency -preserving decomposition into 3 NF is always possible
  • C Loss less, dependency
  • D Any relation with two attributes is BCNF
  • A Eliminate all hidden dependencies
  • B Eliminate the possibility of a insertion anomalies
  • C Have a composite key
  • D Have all non key fields depend on the whole primary key
  • A Key
  • B Key revisited
  • C Superset key
  • D None of the mentioned
  • A Functional dependency
  • B Database modeling
  • C Normalization
  • D Decomposition
  • A Be in Second Normal Form (2NF)
  • B Be in Third Normal Form (3NF)
  • C Have a single attribute key
  • D Have a composite key