ER Model And Business Rules MCQ

Test your knowledge with important ER Model And Business Rules MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more ER Model And Business Rules MCQs on Bissoy. Bissoy App

• It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.
  ক

  True

  খ

  False
• Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.
  ক

  True

  খ

  False
• A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).
  ক

  True

  খ

  False
• A subtype entity name should be which of the following?
  ক

  A singular noun

  খ

  Specific to the organization

  গ

  Concise

  ঘ

  All of the above
• A subtype discriminator is which of the following?
  ক

  An attribute of the supertype whose values determine the subtype

  খ

  An attribute of the subtype whose values determine the supertype

  গ

  An attribute of the supertype whose values determine the supertype

  ঘ

  An attribute of the subtype whose values determine the subtype
• Specialization is which of the following processes?
  ক

  Defining one or more subtypes of the supertype and forming supertype/subtype relationships.

  খ

  Defining one or more supertypes of the subtype and forming supertype/subtype relationships.

  গ

  Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.

  ঘ

  Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
• Which one of the following symbols is not used in an ERD?
  ক

  Rectangle

  খ

  Oval

  গ

  Diamond

  ঘ

  Circle
• A rectangle represents which of the following in an EER?
  ক

  Attribute

  খ

  Entity

  গ

  Optional One

  ঘ

  Relationship
• When an entity instance must be a member of only one subtype, it is which of the following?
  ক

  Disjoint with total specialization

  খ

  Disjoint with partial specialization

  গ

  Overlap with total specialization

  ঘ

  Overlap with partial specialization
• Inheritance is which of the following?
  ক

  When a supertype entity inherits values of the subtype attribute

  খ

  When a subtype entity inherits values of the supertype attribute

  গ

  When a supertype entity inherits values of another supertype attribute

  ঘ

  When a subtype entity inherits values of another subtype attribute
• An oval represents which of the following in an EER?
  ক

  Attribute

  খ

  Entity

  গ

  Optional One

  ঘ

  Relationship
• An action assertion must include which of the following?
  ক

  Anchor object

  খ

  Action

  গ

  Corresponding object

  ঘ

  All of the above