Extended E-R Features MCQ

Test your knowledge with important Extended E-R Features MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Extended E-R Features MCQs on Bissoy. Bissoy App

• ________ is an abstraction through which relationships are treated as higher level entities
  ক

  Creation

  খ

  Superseding

  গ

  Attribute separation

  ঘ

  Aggregation
• If each higher level entity belongs to the lower level entity, then what kind of generalization is it?
  ক

  Modal generalization

  খ

  Partial generalization

  গ

  Total generalization

  ঘ

  None of the mentioned
• Condition defined generalization constraint is also said to be ________
  ক

  Attribute defined

  খ

  Constraint defined

  গ

  Value defined

  ঘ

  Undefined
• Which of the following is not a generalization constraint?
  ক

  Condition-defined

  খ

  User defined

  গ

  Disjoint

  ঘ

  Machine defined
• State true or false: The attributes of the higher level entity sets are inherited by the attributes of the lower level entity sets
  ক

  True

  খ

  False
• Higher level entity sets are designated by the term _________
  ক

  Sub class

  খ

  Super class

  গ

  Parent class

  ঘ

  Root class
• The similarities between the entity set can be expressed by which of the following features?
  ক

  Specialization

  খ

  Generalization

  গ

  Uniquation

  ঘ

  Inheritance
• Which of the following is the specialization that permits multiple sets
  ক

  Superclass specialization

  খ

  Disjoint specialization

  গ

  Overlapping specialization

  ঘ

  None of the mentioned
• State true or false: Specialization can be applied only once
  ক

  True

  খ

  False
• The process of designating sub groupings within the entity set is called as _______
  ক

  Specialization

  খ

  Division

  গ

  Aggregation

  ঘ

  Finalization
• Which of the following is another name for a weak entity?
  ক

  Child

  খ

  Owner

  গ

  Dominant

  ঘ

  All of the mentioned
• Functional dependencies are a generalization of
  ক

  Key dependencies

  খ

  Relation dependencies

  গ

  Database dependencies

  ঘ

  None of the mentioned
• The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?
  ক

  Total

  খ

  Partial

  গ

  Should be specified

  ঘ

  Cannot be determined
• Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________
  ক

  Overlapping

  খ

  Disjointness

  গ

  Uniqueness

  ঘ

  Relational
• A _____________ constraint requires that an entity belong to no more than one lower-level entity set.
  ক

  Disjointness

  খ

  Uniqueness

  গ

  Special

  ঘ

  Relational
• If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
  ক

  Hierarchy

  খ

  Multilevel inheritance

  গ

  Single inheritance

  ঘ

  Multiple inheritance
• There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
  ক

  Commonality

  খ

  Specialization

  গ

  Generalization

  ঘ

  Similarity
• The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.
  ক

  Hierarchy

  খ

  Bottom-up

  গ

  Top-down

  ঘ

  Radical
• Which relationship is used to represent a specialization entity?
  ক

  ISA

  খ

  AIS

  গ

  ONIS

  ঘ

  WHOIS
• The entity set person is classified as student and employee. This process is called _________
  ক

  Generalization

  খ

  Specialization

  গ

  Inheritance

  ঘ

  Constraint generalization