Entity Relationship Modeling Mcqs
Our collections of Multiple choice questions and answers focuses on study of ” DB Entity Relationship Modeling “. These questions are chosen from a collection of most authoritative and best reference books on DBMS.Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate DB Entity Relationship Modeling comprehensively.
2. Type of classes which specifies operations and attributes but corresponding classes are not available are classified as
Abstract classes
Leaf node classes
Overlapping node classes
Shared node classes
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
3. Entity type from which subgroups can be made is classified as
Super class
Subclass
Qualified class
Non-qualified class
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
4. Considering conceptual synthesis and refinement, generalization process is classified as
Conceptual instantiation
Conceptual synthesis
Conceptual refinement
Conceptual identification
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
5. Kind of class which does not have its own subclasses is called
Leaf node
Attribute node
Overlapping node
Disjoint node
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
6. Root super class in diagrams of generalization and specialization is considered as
Three-tier class
Two-tier class
Base class
Top class
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
7. Association between aggregate and primitive objects is classified as
IS-A-SUPERCLASS-OF relationship
IS-A-SUBCLASS-OF relationship
IS-A-COMPONENT-OF relationship
IS-A-PART-OF relationship
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
8. Concept which describes domain of knowledge is considered as
Morphology
Ontology
Anthropology
Terminology
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
9. Considering abstraction concepts, process of assigning similar entities to similar entity types systematically is called
Classification
Instantiation
Identification
Exception abstract
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
10. Category which considers subset of union of entities included in super class is classified
Disjoint super class
Joined super class
Total super class
Partial super class
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
11. Kind of class whose entities belongs to some other data class is called
Concrete classes
Abstract classes
Leaf node classes
Template classes
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
12. According to enhanced-entity relationships, association between super class and subclass is as
Super class is subset of subclass
Subclass is subset of super class
Subclass is partial joint of super class
Super class is partial joint of subclass
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
13. Possible specialization constraint includes
Disjoint and total
Overlapping and total
Overlapping and partial
All of above
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
14. Hierarchy in which each subclass participates in one subclass relationship is classified as
Specialization hierarchy
Generalization hierarchy
Jointness hierarchy
Disjoint hierarchy
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
15. Type of lattice in which a subclass can be class or subclass in more than one association of subclasses is classified as
Attribution lattice
Specialization lattice
Generalization lattice
Disjoint lattice
Answer & Solution
No Solution for this Answer..! Report or Discus this Question