MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In a relation between the entities the type and condition of the relation should be specified . That is called as______attribute. |
| A. | Desciptive |
| B. | Derived |
| C. | Recursive |
| D. | Relative |
| Answer» B. Derived | |
| 2. |
Weak entity set is represented as |
| A. | Underline |
| B. | Double line |
| C. | Double diamond |
| D. | Double rectangle |
| Answer» D. Double rectangle | |
| 3. |
Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them. |
| A. | Entity |
| B. | Attribute |
| C. | Relation |
| D. | Value |
| Answer» B. Attribute | |
| 4. |
The total participation by entities is represented in E-R diagram as |
| A. | Dashed line |
| B. | Double line |
| C. | Double rectangle |
| D. | Circle |
| Answer» C. Double rectangle | |
| 5. |
Statement 1: We can create foreign key constraints on relational schema derived from ER diagramStatement 2: Relational schema cannot be derived from an ER diagram |
| A. | Both the statements are true |
| B. | Both the statements are false |
| C. | Statement 1 is true and Statement 2 is false |
| D. | Statement 2 is true and statement 1 is false |
| Answer» D. Statement 2 is true and statement 1 is false | |
| 6. |
A window into a portion of a database is |
| A. | Schema |
| B. | View |
| C. | Query |
| D. | Data dictionary |
| Answer» C. Query | |
| 7. |
Which relationship is used to represent a specialization entity ? |
| A. | ISA |
| B. | AIS |
| C. | ONIS |
| D. | WHOIS |
| Answer» B. AIS | |
| 8. |
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 _____________ |
| A. | Overlapping |
| B. | Disjointness |
| C. | Uniqueness |
| D. | Relational |
| Answer» B. Disjointness | |
| 9. |
The completeness constraint may be one of the following: Total generalization or specialization , Partial generalization or specialization . Which is the default ? |
| A. | Total |
| B. | Partial |
| C. | Should be specified |
| D. | Cannot be determined |
| Answer» C. Should be specified | |
| 10. |
Functional dependencies are a generalization of |
| A. | Key dependencies |
| B. | Relation dependencies |
| C. | Database dependencies |
| D. | None of the mentioned |
| Answer» B. Relation dependencies | |
| 11. |
Consider the relation given below and ind the maximum normal form applicable to them1. R(A, B) WITH productions { A > B }2. R(A, B) WITH productions { B > A }3. R(A, B) WITH productions {A > B, B > A }4. R(A, B, C) WITH productions {A >B, B > A, AB > C } |
| A. | 1, 2 and 3 are in 3NF and 4 is in BCNF |
| B. | 1 and 2 are in BCNF and 3 and 4 are in 3NF |
| C. | All are in 3NF |
| D. | All are in BCNF |
| Answer» E. | |
| 12. |
In the modeling of union type classes, the total category of super class is represented by |
| A. | Triple line |
| B. | Double line |
| C. | Single line |
| D. | Inverted comma |
| Answer» C. Single line | |
| 13. |
The category which considers the union of super class entities is called |
| A. | Total super class |
| B. | Partial super class |
| C. | Disjoint super class |
| D. | Joined super class |
| Answer» B. Partial super class | |
| 14. |
Considering the conceptual synthesis and refinement, the specialization process is classified as |
| A. | Conceptual refinement |
| B. | Conceptual identification |
| C. | Conceptual instantiation |
| D. | Conceptual synthesis |
| Answer» E. | |
| 15. |
If the super class contains the entities in subclasses and is derived from super class then the super class is considered as |
| A. | Total |
| B. | Partial |
| C. | Overlap |
| D. | Disjoint |
| Answer» B. Partial | |
| 16. |
The process of defining the entity type subclasses is classified as |
| A. | Type inheritance |
| B. | Visualization |
| C. | Specialization |
| D. | Generalization |
| Answer» D. Generalization | |
| 17. |
The entity types, super classes and subclasses are classified as |
| A. | ER schema overlapping |
| B. | ER schema functions |
| C. | ER schema objects |
| D. | EER schema constructs |
| Answer» E. | |
| 18. |
The root super class in diagrams of generalization and specialization is considered as |
| A. | Three-tier class |
| B. | Two-tier class |
| C. | Base class |
| D. | Top class |
| Answer» D. Top class | |
| 19. |
The concept which describes the domain of knowledge is considered as |
| A. | Morphology |
| B. | Ontology |
| C. | Anthropology |
| D. | Terminology |
| Answer» C. Anthropology | |
| 20. |
Considering abstraction concepts, the process of assigning the similar entities to similar entity types systematically is called |
| A. | Classification |
| B. | Instantiation |
| C. | Identification |
| D. | Exception abstract |
| Answer» B. Instantiation | |
| 21. |
The category which considers the subset of union of entities included in super class is classified |
| A. | Disjoint super class |
| B. | Joined super class |
| C. | Total super class |
| D. | Partial super class |
| Answer» E. | |
| 22. |
The kind of class whose entities belongs to some other data class is called |
| A. | Concrete classes |
| B. | Abstract classes |
| C. | Leaf node classes |
| D. | Template classes |
| Answer» B. Abstract classes | |
| 23. |
According to enhanced-entity relationships, the association between super class and subclass is as |
| A. | Super class is subset of subclass |
| B. | Subclass is subset of super class |
| C. | Subclass is partial joint of super class |
| D. | Super class is partial joint of subclass |
| Answer» C. Subclass is partial joint of super class | |
| 24. |
The possible specialization constraint includes |
| A. | Disjoint and total |
| B. | Overlapping and total |
| C. | Overlapping and partial |
| D. | All of above |
| Answer» E. | |
| 25. |
The hierarchy in which each subclass participates in one subclass relationship is classified as |
| A. | Specialization hierarchy |
| B. | Generalization hierarchy |
| C. | Jointness hierarchy |
| D. | Disjoint hierarchy |
| Answer» B. Generalization hierarchy | |
| 26. |
The type of lattice in which a subclass can be class or subclass in more than one association of subclasses is classified as |
| A. | Attribution lattice |
| B. | Specialization lattice |
| C. | Generalization lattice |
| D. | Disjoint lattice |
| Answer» C. Generalization lattice | |
| 27. |
In the process of specialization, the subclasses are attached by |
| A. | Lines |
| B. | Dotted lines |
| C. | Red lines |
| D. | Red dotted lines |
| Answer» B. Dotted lines | |
| 28. |
The kind of subclass on which the entity become part of subclass by putting some condition on attribute values is classified as |
| A. | Predicate segregation subclass |
| B. | Predicate aggregation subclass |
| C. | Predicate-defined subclass |
| D. | Indicate-defined subclass |
| Answer» D. Indicate-defined subclass | |
| 29. |
The kind of subclass in which there are no constraints for deciding membership in any given subclass is classified as |
| A. | Visual subclass |
| B. | User-defined subclass |
| C. | Member subclass |
| D. | Local subclass |
| Answer» C. Member subclass | |
| 30. |
Considering the knowledge representation and conceptual modeling, the reasoning mechanisms are classified as part of |
| A. | Functional modeling |
| B. | Concrete modeling |
| C. | Knowledge representation |
| D. | Conceptual modeling |
| Answer» D. Conceptual modeling | |
| 31. |
The main constraints applicable in specialization are |
| A. | Disjointness constraint |
| B. | Incomplete constraint |
| C. | Completeness constraint |
| D. | Both a and c |
| Answer» E. | |
| 32. |
The association between aggregate and primitive objects is classified as |
| A. | IS-A-SUPERCLASS-OF relationship |
| B. | IS-A-SUBCLASS-OF relationship |
| C. | IS-A-COMPONENT-OF relationship |
| D. | IS-A-PART-OF relationship |
| Answer» E. | |
| 33. |
The subclass which has more than one super class is called |
| A. | Partial subclass |
| B. | Shared subclass |
| C. | Shared super class |
| D. | Joint super class |
| Answer» C. Shared super class | |
| 34. |
The type of subclass constraint that one entity can be member of at most one subclass is classified as |
| A. | Incomplete joint constraint |
| B. | Complete joint constraint |
| C. | Disjointness constraint |
| D. | Jointness constraint |
| Answer» D. Jointness constraint | |
| 35. |
In UML class diagrams, the inheritances that are permitted includes |
| A. | Single inheritance |
| B. | Multiple inheritance |
| C. | Shared schema inheritance |
| D. | Both a and b |
| Answer» E. | |
| 36. |
The leaf nodes in diagrams of generalization and specialization are considered as |
| A. | Extension classes |
| B. | Leaf classes |
| C. | Inverted classes |
| D. | Diverted classes |
| Answer» C. Inverted classes | |
| 37. |
The concept in which the shared subclass take over the relationship from multiple classes is considered as |
| A. | Joint inheritance |
| B. | Partial inheritance |
| C. | Multiple inheritance |
| D. | Independent inheritance |
| Answer» D. Independent inheritance | |
| 38. |
The IS-AN-INSTANCE-OF and IS-A-MEMBER-OF are types of relationships to associate |
| A. | Object instance to object class |
| B. | Leaf instance to node class |
| C. | Union instance to object class |
| D. | Intersect instance to object class |
| Answer» B. Leaf instance to node class | |
| 39. |
The generalization and specialization lattices are classified as |
| A. | Single aggregation |
| B. | Multiple inheritance |
| C. | Single inheritance |
| D. | Multiple aggregation |
| Answer» C. Single inheritance | |
| 40. |
The inverse process of classification which focuses on specific examination of different entities of classes is called |
| A. | Identification |
| B. | Exception abstract |
| C. | Classification |
| D. | Instantiation |
| Answer» E. | |
| 41. |
The type of attributes that are applicable to specific subclasses is classified as |
| A. | Aggregate attributes |
| B. | Segregate attributes |
| C. | Public attributes |
| D. | Local attributes |
| Answer» E. | |
| 42. |
The type of specialization in which all the subclasses have membership condition on super class of similar attribute is classified as |
| A. | Constraint-defined specialization |
| B. | Key-defined specialization |
| C. | Entity-defined specialization |
| D. | Attribute-defined specialization |
| Answer» E. | |
| 43. |
The identification, aggregation and instantiation are abstraction concepts used in |
| A. | Intension and extension models |
| B. | Classes and nodes models |
| C. | Concrete models |
| D. | Semantic data models |
| Answer» E. | |
| 44. |
If there is no association between aggregate and primitive objects then this can be represented as |
| A. | IS-A-COMPONENT-OF relationship |
| B. | IS-A-PART-OF relationship |
| C. | IS-A-SUPERCLASS-OF relationship |
| D. | IS-A-SUBCLASS-OF relationship |
| Answer» B. IS-A-PART-OF relationship | |
| 45. |
In the process of specialization, the specific attributes are also classified as |
| A. | Public attributes |
| B. | Local attributes |
| C. | Aggregate attributes |
| D. | Segregate attributes |
| Answer» C. Aggregate attributes | |
| 46. |
The predicate-defined subclasses are also known as |
| A. | Condition-defined subclasses |
| B. | Non condition subclasses |
| C. | Aggregation subclasses |
| D. | Segregation subclasses |
| Answer» B. Non condition subclasses | |
| 47. |
The kind of entities without any key attributes are classified as |
| A. | Weak entity |
| B. | Strong entity |
| C. | Single entity |
| D. | Foreign entity |
| Answer» B. Strong entity | |
| 48. |
The process of abstraction in which the objects and classes are identified with some kind of identifier is classified as |
| A. | Classification |
| B. | Instantiation |
| C. | Identification |
| D. | Exception abstract |
| Answer» D. Exception abstract | |
| 49. |
The most popular high level conceptual model in database management system is |
| A. | Close end relation model |
| B. | Query relation model |
| C. | Entity relationship model |
| D. | Attribute relationship model |
| Answer» D. Attribute relationship model | |
| 50. |
The maximum number of instances that can participate into the binary relationship is classified as |
| A. | Floating ratio |
| B. | Cardinality ratio |
| C. | Intensive ratio |
| D. | Extensive ratio |
| Answer» C. Intensive ratio | |