Data Models Into Database Designs MCQ

Test your knowledge with important Data Models Into Database Designs MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Data Models Into Database Designs MCQs at Bissoy

• An ideal primary key is short, numeric and seldom changing.
  ক

  True

  খ

  False
• For every relationship, there are six possible referential integrity actions.
  ক

  True

  খ

  False
• When the parent entity is required, a new parent row can always be inserted.
  ক

  True

  খ

  False
• When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
  ক

  True

  খ

  False
• (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
  ক

  True

  খ

  False
• When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
  ক

  True

  খ

  False
• Surrogate keys have much meaning for users.
  ক

  True

  খ

  False
• When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
  ক

  True

  খ

  False
• Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
  ক

  True

  খ

  False
• The DBMS allows surrogate keys to be changed.
  ক

  True

  খ

  False
• An intersection table is required to represent M:N relationships.
  ক

  True

  খ

  False
• For every relationship, there are six possible sets of minimum cardinalities.
  ক

  True

  খ

  False
• Intersection tables are ID-dependent on both their parent tables.
  ক

  True

  খ

  False
• All primary keys are required.
  ক

  True

  খ

  False
• When the parent entity is required, a new child row can always be inserted.
  ক

  True

  খ

  False
• In a 1:1 relationship, the primary key placement is arbitrary.
  ক

  True

  খ

  False
• When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
  ক

  True

  খ

  False
• In 1:N relationships, which entity becomes the parent entity is arbitrary.
  ক

  True

  খ

  False
• The terms alternate key and candidate key mean the same thing.
  ক

  True

  খ

  False
• A foreign key is used to implement relationships between tables.
  ক

  True

  খ

  False
• 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
• 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
• For every relationship, how many possible sets of minimum cardinalities are there?
  ক

  Two

  খ

  Three

  গ

  Four

  ঘ

  Six
• Each entity is represented as a(n):
  ক

  tuple.

  খ

  table.

  গ

  attribute.

  ঘ

  file.
• 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
• Which is not true about surrogate keys?
  ক

  They are short.

  খ

  They are fixed.

  গ

  They have meaning to the user.

  ঘ

  They are numeric.
• 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.
• 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
• The identifier of an entity will become the ________ of the new table.
  ক

  foreign key

  খ

  main attribute

  গ

  primary key

  ঘ

  identity key
• Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
  ক

  Null status

  খ

  Data type

  গ

  Default value

  ঘ

  Data constraints