Database - Data Models into Database Designs

Database - Data Models into Database Designs
11. The identifier of an entity will become the ________ of the new table.
  • foreign key
  • main attribute
  • primary key
  • identity key
Show Answer
12. 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 domain constraint
  • A range constraint
  • An intrarelation constraint
  • An interrelation constraint
Show Answer
13. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
  • primary key.
  • foreign key.
  • composite key.
  • surrogate key.
Show Answer
14. Which is not true about surrogate keys?
  • They are short.
  • They are fixed.
  • They have meaning to the user.
  • They are numeric.
Show Answer
15. For every relationship, how many possible types of actions are there when enforcing
minimum cardinalities?
  • Two
  • Three
  • Four
  • Six
Show Answer
16. Which constraint requires that the binary relationship indicate all combinations that must
appear in the ternary relationship?
  • MUST COVER
  • MUST NOT
  • Both of the above.
  • None of the above is correct.
Show Answer
17. Each entity is represented as a(n):
  • tuple.
  • table.
  • attribute.
  • file.
Show Answer
18. For every relationship, how many possible sets of minimum cardinalities are there?
  • Two
  • Three
  • Four
  • Six
Show Answer
19. 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
  • any alternate key
  • a surrogate key
  • a foreign key
Show Answer
20. Which of the following column properties would be used to specify that cells in a column
must contain a monetary value that is less than another monetary value in the same row?
  • Null status
  • Data type
  • Default value
  • Data constraints
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test