Normalization MCQ

Test your knowledge with important Normalization MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Normalization MCQs at Bissoy

• Which of the following is not a restriction for a table to be a relation?
  ক

  The cells of the table must contain a single value

  খ

  All of the entries in any column must be of the same kind

  গ

  The columns must be ordered

  ঘ

  No two rows in a table may be identical
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
  ক

  Transitive Dependency

  খ

  Insertion Anomaly

  গ

  Referential Integrity Constraint

  ঘ

  Normal Form
• Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
  ক

  A -> B

  খ

  A -> C

  গ

  A -> (B,C)

  ঘ

  (B,C) -> A
• Anomalies are avoided by splitting the offending relation into multiple relations, is also known as
  ক

  Accupressure

  খ

  Decomposition

  গ

  Precomposition

  ঘ

  Both Decomposition and Precomposition
• In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.
  ক

  Candidate

  খ

  Join

  গ

  Functional

  ঘ

  None of the Mentioned
• A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.
  ক

  Multivalued Dependencies

  খ

  Join Dependency

  গ

  Trivial Functional Dependency

  ঘ

  Transitive Dependencies
• Every constraint on the table is a logical consequence of the table’s
  ক

  Fourth normal form

  খ

  Fifth normal form

  গ

  Domain/key normal form

  ঘ

  None of the Mentioned
• A table is in 3NF if it is in 2NF and if it has no ____________
  ক

  Functional Dependencies

  খ

  Transitive Dependencies

  গ

  Trivial Functional Dependency

  ঘ

  Multivalued Dependencies
• The ___________ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.
  ক

  Third

  খ

  Fourth

  গ

  Fifth

  ঘ

  Sixth
• A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
  ক

  Dependent

  খ

  Normal

  গ

  Candidate

  ঘ

  Both Normal and Candidate