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

Data Models into Database Designs

Data Models into Database Designs
Which is not true about surrogate keys?

They are fixed.
They have meaning to the user.
They are short.
They are numeric.

ANSWER DOWNLOAD EXAMIANS APP

Data Models into Database Designs
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Data Models into Database Designs
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

A range constraint
An intrarelation constraint
An interrelation constraint
A domain constraint

ANSWER DOWNLOAD EXAMIANS APP

Data Models into Database Designs
A primary key should be defined as:

Either of the above can be used.
NULL.
None of these
NOT NULL.

ANSWER DOWNLOAD EXAMIANS APP

Data Models into Database Designs
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Data Models into Database Designs
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

the primary key
a foreign key
any alternate key
a surrogate key

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Data Models into Database Designs

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
↑