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 _____ a parent record type can be linked to one or more child record types, but a child record type can have only one parent. |
| A. | Network database |
| B. | Relational database |
| C. | Distributed database |
| D. | Hierarchical database |
| Answer» E. | |
| 2. |
In two-tier client - server architecture, the running of application programs and the user interface programs is in control of |
| A. | Modulation side |
| B. | Client side |
| C. | Server side |
| D. | Host side |
| Answer» C. Server side | |
| 3. |
What data is stored ? is described by __________ level of abstraction in DBMS. |
| A. | Physical |
| B. | View |
| C. | Conceptual |
| D. | None of the above |
| Answer» D. None of the above | |
| 4. |
The Object Query Language is which of the following ? |
| A. | Similar to SQL and uses a select-from-where structure |
| B. | Similar to SQL and uses a select-where structure |
| C. | Similar to SQL and uses a from-where structure |
| D. | Not similar to SQL |
| Answer» B. Similar to SQL and uses a select-where structure | |
| 5. |
The keyword inverse is used in which of the following? |
| A. | Class |
| B. | Attribute |
| C. | Relationship |
| D. | All of the above. |
| Answer» D. All of the above. | |
| 6. |
In two-tier client - server architecture, the functions of transaction server and query server are controlled by |
| A. | Server side |
| B. | Host side |
| C. | Modulation side |
| D. | Client side |
| Answer» B. Host side | |
| 7. |
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 | |
| 8. |
Relationship type with two degrees is classified as |
| A. | Extension association |
| B. | Intension association |
| C. | Binary relationship |
| D. | Ternary relationship |
| Answer» D. Ternary relationship | |
| 9. |
Constraint which specifies 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 | |
| 10. |
In commercial database management system, relational database model is also known as |
| A. | Implementation data model |
| B. | Attribution data model |
| C. | Sequential data model |
| D. | Functional data model |
| Answer» B. Attribution data model | |
| 11. |
In constructing ER diagrams, double ovals are used to denote |
| A. | Multi-value table |
| B. | Multi-value entity |
| C. | Multi-value attributes |
| D. | Multi-value key |
| Answer» D. Multi-value key | |
| 12. |
Total participation constraint is also known as |
| A. | Recursive dependency |
| B. | Existence dependency |
| C. | Existence independency |
| D. | Recursive independency |
| Answer» C. Existence independency | |
| 13. |
Weak entities are represented in UML diagrams by using aggregations called |
| A. | Qualified segregation |
| B. | Non-qualified segregation |
| C. | Non-qualified aggregation |
| D. | Qualified aggregation |
| Answer» E. | |
| 14. |
Attributes which have only more than one value for a specific entity are classified as |
| A. | Atomic attributes |
| B. | Diatomic attributes |
| C. | Multi-valued attributes |
| D. | Single valued attributes |
| Answer» D. Single valued attributes | |
| 15. |
Types of partial constraints are |
| A. | Total and partial |
| B. | Intensive and extensive |
| C. | Minimum and maximum |
| D. | Floating and string |
| Answer» B. Intensive and extensive | |
| 16. |
Phase in data designing in which access paths and database indexes are specified is classified as |
| A. | Structural design |
| B. | Physical design of database |
| C. | Data model mapping |
| D. | Logical design |
| Answer» C. Data model mapping | |
| 17. |
Attributes which have only one value for a specific entity are called |
| A. | Multi-valued attributes |
| B. | Single valued attributes |
| C. | Atomic attributes |
| D. | Diatomic attributes |
| Answer» C. Atomic attributes | |
| 18. |
In programming languages, available data types are |
| A. | Integer |
| B. | String |
| C. | Float and Boolean |
| D. | All of above |
| Answer» E. | |
| 19. |
Kind of constraint which cannot let two entities to have similar values is classified as |
| A. | Derived constraints |
| B. | Composite value constraint |
| C. | Uniqueness constraint |
| D. | Multi valued constraint |
| Answer» D. Multi valued constraint | |
| 20. |
Data model in which relationships are explained in terms of attributes is classified as |
| A. | Functional data models |
| B. | Binary data models |
| C. | Ternary data models |
| D. | Extension data model |
| Answer» B. Binary data models | |
| 21. |
First step in designing high level conceptual data model is |
| A. | Logical design analysis |
| B. | Conceptual design analysis |
| C. | Functional requirement analysis |
| D. | Requirement analysis |
| Answer» E. | |