Data Models into Database Designs Questions and Answers

Practice Mode
Showing 10 of 20 questions
Q11
The identifier of an entity will become the ________ of the new table.
  • A foreign key
  • B main attribute
  • C primary key
  • D identity key
Answer: Option C
Q12
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 A domain constraint
  • B A range constraint
  • C An intrarelation constraint
  • D An interrelation constraint
Answer: Option C
Q13
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
  • A primary key.
  • B foreign key.
  • C composite key.
  • D surrogate key.
Answer: Option D
Q14
Which is not true about surrogate keys?
  • A They are short.
  • B They are fixed.
  • C They have meaning to the user.
  • D They are numeric.
Answer: Option C
Q15
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
  • A Two
  • B Three
  • C Four
  • D Six
Answer: Option D
Q16
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
  • A MUST COVER
  • B MUST NOT
  • C Both of the above.
  • D None of the above is correct.
Answer: Option A
Q17
Each entity is represented as a(n):
  • A tuple.
  • B table.
  • C attribute.
  • D file.
Answer: Option B
Q18
For every relationship, how many possible sets of minimum cardinalities are there?
  • A Two
  • B Three
  • C Four
  • D Six
Answer: Option C
Q19
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.
  • A the primary key
  • B any alternate key
  • C a surrogate key
  • D a foreign key
Answer: Option A
Q20
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?
  • A Null status
  • B Data type
  • C Default value
  • D Data constraints
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test