MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
State true or false: A weak entity can participate in all the relationships. |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
State true or false: Every weak entity set must be associated with an identifying entity |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
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. | |
| 4. |
What does a directed line ( → ) from a relationship set to two entity sets mean? |
| A. | One-one |
| B. | Many-one |
| C. | Many-many |
| D. | One-many |
| Answer» B. Many-one | |
| 5. |
What do double diamonds represent in an ER diagram |
| A. | They link entity sets to relationship sets |
| B. | Total participation of an entity in a relationship set |
| C. | Relationship sets linked to weak entity sets |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 6. |
Which of the following symbols represent relationship sets in an ER diagram |
| A. | Divided rectangles |
| B. | Diamonds |
| C. | Lines |
| D. | Undivided rectangles |
| Answer» C. Lines | |
| 7. |
Which of the following symbols represent entity sets in an ER diagram? |
| A. | Divided rectangles |
| B. | Diamonds |
| C. | Lines |
| D. | Undivided rectangles |
| Answer» B. Diamonds | |
| 8. |
STATE_TRUE_OR_FALSE:_A_WEAK_ENTITY_CAN_PARTICIPATE_IN_ALL_THE_RELATIONSHIPS.?$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
State true or false: Every weak entity set must be associated with an identifying entit? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
The relationship associating the weak entity sets with the identifying entity set is called as ________ |
| A. | Identifying relationship |
| B. | Connecting relationship |
| C. | Completing relationship |
| D. | Unique relationship |
| Answer» B. Connecting relationship | |
| 11. |
An entity set that has a primary key is called as ___________ |
| A. | Strong entity set |
| B. | Weak entity set |
| C. | Complete entity set |
| D. | None of the mentioned |
| Answer» B. Weak entity set | |
| 12. |
How is the discriminator of a weak entity set specified? |
| A. | Using a solid line |
| B. | Circling it |
| C. | Using a dashed line |
| D. | Drawing a square around it |
| Answer» D. Drawing a square around it | |
| 13. |
What does a directed line ( ‚Üí ) from a relationship set to two entity sets mean?$ |
| A. | One-one |
| B. | Many-one |
| C. | Many-many |
| D. | One-many |
| Answer» B. Many-one | |