• HOME
  • QUIZ
  • CONTACT US
EXAMIANS
  • COMPUTER
  • CURRENT AFFAIRS
  • ENGINEERING
    • Chemical Engineering
    • Civil Engineering
    • Computer Engineering
    • Electrical Engineering
    • Mechanical Engineering
  • ENGLISH GRAMMAR
  • GK
  • GUJARATI MCQ

Database Design Using Normalization

Database Design Using Normalization
Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Database Design Using Normalization
When building a database from an existing set of tables, we still need to consider normalization principles.

True
False

ANSWER DOWNLOAD EXAMIANS APP

Database Design Using Normalization
Read-only databases are ________ updated.

commonly
never
always
seldom

ANSWER DOWNLOAD EXAMIANS APP

Database Design Using Normalization
Multivalued dependencies should ________ be eliminated.

never
seldom
always
commonly

ANSWER DOWNLOAD EXAMIANS APP

Database Design Using Normalization
If a table has been normalized so that all determinants are candidate keys, then that table is in:

3NF.
BCNF.
1NF.
2NF.

ANSWER DOWNLOAD EXAMIANS APP

Database Design Using Normalization
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.

either an advantage or disadvantage
disadvantage
advantage
neither an advantage nor disadvantage

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Database Design Using Normalization

DOWNLOAD APP

  • APPLE
    from app store
  • ANDROID
    from play store

SEARCH

LOGIN HERE


  • GOOGLE

FIND US

  • 1.70K
    FOLLOW US
  • EXAMIANSSTUDY FOR YOUR DREAMS.
  • SUPPORT :SUPPORT EMAIL ACCOUNT : examians@yahoo.com

OTHER WEBSITES

  • GUJARATI MCQ
  • ACCOUNTIANS

QUICK LINKS

  • HOME
  • QUIZ
  • PRIVACY POLICY
  • DISCLAIMER
  • TERMS & CONDITIONS
  • CONTACT US
↑