Materialized Views MCQ

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

• The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in
  ক

  1NF only

  খ

  2NF and hence also in 1NF

  গ

  3NF and hence also in 2NF and 1NF

  ঘ

  BCNF and hence also in 3NF, 2NF and 1NF
• Which one of the following statements about normal forms is FALSE?
  ক

  BCNF is stricter than 3NF

  খ

  Lossless, dependency-preserving decomposition into 3NF is always possible

  গ

  Lossless, dependency-preserving decomposition into BCNF is always possible

  ঘ

  Any relation with two attributes is in BCNF
• Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is
  ক

  dependency preserving and lossless join

  খ

  lossless join but not dependency preserving

  গ

  dependency preserving but not lossless join

  ঘ

  not dependency preserving and not lossless join