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. |
The entities that have key attributes to be distinct are considered as |
| A. | Weak entity |
| B. | Strong entity |
| C. | Single entity |
| D. | Foreign entity |
| Answer» C. Single entity | |
| 2. |
The schema which specifies that all the database users requirements have been met is called |
| A. | High level conceptual schema |
| B. | High level logical schema |
| C. | High level structural schema |
| D. | High level detailed schema |
| Answer» B. High level logical schema | |
| 3. |
For a relationship type, the participation constraints and cardinality ratio are considered together to make |
| A. | Intensive constraints |
| B. | Recursive constraints |
| C. | Composite constraints |
| D. | Structural constraints |
| Answer» E. | |
| 4. |
The parent entity type or identifying entity type are considered as other names of |
| A. | Dominant entity type |
| B. | Non dominant entity type |
| C. | Composite entity type |
| D. | Non foreign entity type |
| Answer» B. Non dominant entity type | |
| 5. |
The relationship type with two degrees is classified as |
| A. | Extension association |
| B. | Intension association |
| C. | Binary relationship |
| D. | Ternary relationship |
| Answer» D. Ternary relationship | |
| 6. |
The constraint which specifies the minimum number of relationship instances is classified as |
| A. | Participation constraint |
| B. | Non-participation constraint |
| C. | Extensive constraint |
| D. | Intensive constraint |
| Answer» B. Non-participation constraint | |
| 7. |
The databases which are used to represent reference attributes are classified as |
| A. | Ternary databases |
| B. | String databases |
| C. | Floating databases |
| D. | Object databases |
| Answer» E. | |
| 8. |
In the entity-relationship diagram, the partial key is sometimes also called |
| A. | Subordinate |
| B. | Discriminator |
| C. | Incremental |
| D. | Cartesian ordinate |
| Answer» C. Incremental | |
| 9. |
The Universal Modeling Language in database management system is classified as |
| A. | Object modeling methodology |
| B. | Query modeling methodology |
| C. | Entity modeling methodology |
| D. | Attribute modeling methodology |
| Answer» B. Query modeling methodology | |
| 10. |
In ER diagrams, the existence dependency is shown by |
| A. | Double dotted line |
| B. | Triple dotted line |
| C. | Single line |
| D. | Double line |
| Answer» E. | |
| 11. |
In entity set, the type of attribute having distinct values for specific entity is classified as |
| A. | Functional attribute |
| B. | Logical attribute |
| C. | Key entity |
| D. | Key attribute |
| Answer» E. | |
| 12. |
In E-R diagrams, the relationship type with three degrees is classified as |
| A. | Binary relationship |
| B. | Ternary relationship |
| C. | Extension association |
| D. | Intension association |
| Answer» C. Extension association | |
| 13. |
In relational databases, the key which are considered as type of reference attribute is classified as |
| A. | Foreign keys |
| B. | Composite keys |
| C. | String keys |
| D. | Floating keys |
| Answer» B. Composite keys | |
| 14. |
The step of high level conceptual models designing in which the data requirements are documented by interviewing database users is |
| A. | Host server analysis |
| B. | Requirement collection and analysis |
| C. | Client server analysis |
| D. | Entity attribute analysis |
| Answer» C. Client server analysis | |
| 15. |
The identifying entity type is also known as |
| A. | Owner entity type |
| B. | String entity type |
| C. | Evidence entity |
| D. | Floating entity |
| Answer» B. String entity type | |
| 16. |
The step in database design in which the high level data model is converted into the model of data implementation is considered as |
| A. | Physical design of database |
| B. | Data model mapping |
| C. | Logical design |
| D. | Both a and c |
| Answer» E. | |
| 17. |
In UML diagrams, the relationship between the object and component parts is represented by |
| A. | Ordination |
| B. | Aggregation |
| C. | Segregation |
| D. | Increment |
| Answer» C. Segregation | |
| 18. |
In the modeling of union type classes, the partial category of super class is represented by |
| A. | Single line |
| B. | Inverted comma |
| C. | Triple line |
| D. | Double line |
| Answer» B. Inverted comma | |
| 19. |
The type of classes which specifies the operations and attributes but the corresponding classes are not available are classified as |
| A. | Abstract classes |
| B. | Leaf node classes |
| C. | Overlapping node classes |
| D. | Shared node classes |
| Answer» B. Leaf node classes | |
| 20. |
The entity type from which the subgroups can be made is classified as |
| A. | Super class |
| B. | Subclass |
| C. | Qualified class |
| D. | Non-qualified class |
| Answer» C. Qualified class | |
| 21. |
Considering the conceptual synthesis and refinement, the generalization process is classified as |
| A. | Conceptual instantiation |
| B. | Conceptual synthesis |
| C. | Conceptual refinement |
| D. | Conceptual identification |
| Answer» C. Conceptual refinement | |
| 22. |
The kind of class which does not have its own subclasses is called |
| A. | Leaf node |
| B. | Attribute node |
| C. | Overlapping node |
| D. | Disjoint node |
| Answer» B. Attribute node | |
| 23. |
Considering the constraints of generalization and specialization, the constraint of disjointness and completeness is usually |
| A. | Non calculated |
| B. | Non defined |
| C. | Independence |
| D. | Dependence |
| Answer» D. Dependence | |
| 24. |
The relationship between vocabulary to represent different concepts is classified as |
| A. | Dictionary |
| B. | Thesaurus |
| C. | Glossary |
| D. | All of above |
| Answer» E. | |
| 25. |
Consider representation of specialization and generalization, the blank triangle is used to indicate the specific constraint called |
| A. | Disjoint node |
| B. | Shared base constraint |
| C. | Schema construct |
| D. | Disjoint constraint |
| Answer» E. | |
| 26. |
The Web project which allows exchange of information among different computers on Web is classified as |
| A. | Segregate web |
| B. | Conceptual web |
| C. | Semantic web |
| D. | Aggregate web |
| Answer» D. Aggregate web | |
| 27. |
In the enhanced-entity-relationship, the collection of entities in the form of set is classified as |
| A. | Object |
| B. | Schema |
| C. | Class |
| D. | Construct |
| Answer» D. Construct | |
| 28. |
The entity involved in the process of specialization is considered as |
| A. | Medium class of entity |
| B. | Mini class of entity |
| C. | Subclass of entity |
| D. | Super class of entity |
| Answer» E. | |
| 29. |
The subclass which represent objects collection of distinct entity types is classified as |
| A. | Partial type |
| B. | Intersection type |
| C. | Union type |
| D. | Both b and c |
| Answer» E. | |
| 30. |
The procedure of building composite objects from components of objects is classified as |
| A. | Aggregation |
| B. | Segregation |
| C. | Aggregate synthesis |
| D. | Aggregate refinement |
| Answer» B. Segregation | |
| 31. |
Consider representation of specialization and generalization, the filled triangle is used to indicate the constraint called |
| A. | Overlapping constraint |
| B. | Disjoint node |
| C. | Shared base constraint |
| D. | Schema construct |
| Answer» B. Disjoint node | |
| 32. |
How are roles specified in an ER diagram |
| A. | By labelling the rectangles |
| B. | By labelling the diamonds |
| C. | Roles cannot be specified in an ER diagram |
| D. | By labelling the lines |
| Answer» E. | |
| 33. |
If every non-key attribute is functionally depedent primary key, then the relation will be in |
| A. | First normal form |
| B. | Second normal form |
| C. | Third form |
| D. | Fourth normal form |
| Answer» C. Third form | |
| 34. |
The term for information that describes what type of data is available in a database is: |
| A. | Data dictionary |
| B. | Data repository |
| C. | Index data |
| D. | Metadata |
| Answer» E. | |
| 35. |
A data type that creates unique numbers for key columns in Microsoft Access is: |
| A. | Autonumber |
| B. | Boolean |
| C. | Sequential key |
| D. | Sequential number |
| Answer» B. Boolean | |
| 36. |
A dependency exist between two columns when |
| A. | Together they constitute a composite key for the table |
| B. | Knowing the value in one column determines the value stored in another column |
| C. | The table is in 3NF |
| D. | Together they constitute a foreign key |
| Answer» B. Knowing the value in one column determines the value stored in another column | |
| 37. |
____________ is preferred method for enforcing data integrity |
| A. | Constraints |
| B. | Stored Procedure |
| C. | Triggers |
| D. | Cursors |
| Answer» B. Stored Procedure | |
| 38. |
Which of the following gives a logical structure of the database graphically ? |
| A. | Entity-relationship diagram |
| B. | Entity diagram |
| C. | Database diagram |
| D. | Architectural representation |
| Answer» B. Entity diagram | |
| 39. |
The entity relationship set is represented in E-R diagram as |
| A. | Double diamonds |
| B. | Undivided rectangles |
| C. | Dashed lines |
| D. | Diamond |
| Answer» E. | |
| 40. |
Type of classes which specifies operations and attributes but corresponding classes are not available are classified as |
| A. | Abstract classes |
| B. | Leaf node classes |
| C. | Overlapping node classes |
| D. | Shared node classes |
| Answer» B. Leaf node classes | |