Home

Communicator
Tools
Profile Settings
Loading, please wait ...
Open its course - Database Systems

Multiple Choice Questions for Normalization

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

  • 1 Which type of dependency is removed in 2nd normal form to make the relation(s) full functional dependent:
    1. Full functional dependency
    2. Partial dependency
    3. Transitive dependency
    4. None of above
  • 2 One goal to eliminate various anomalies in relational database is to:
    1. Reduce attributes
    2. Reduce tables
    3. Increase data
    4. Reduce storage space
  • 3 _____________ is the most efficient method to reduce the duplication of data.
    1. Deletion
    2. Normalization
    3. Alter
    4. none of the above
  • 4 For some relations, updating the data can have undesirable consequences called
    1. Referential integrity
    2. Insertion anamoly
    3. Deletion anamoly
    4. Modification anamoly
  • 5 A table is in 1NF but not in 2NF if in the table:
    1. There are no repeating groups but have partial dependency
    2. There are repeating groups
    3. There are repeating groups but no transitive dependency
    4. None
About Us
Who we are Privacy Policy Terms of Use
Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Products / Utilites
Attendance Mapper Industry Liason Cell (ILC) Smart Secretary
Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert