MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 21 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Involute splines have stub teeth with a pressure angle of ___ |
| A. | 30 |
| B. | 45 |
| C. | 60 |
| D. | Can’t be determined |
| Answer» C. 60 | |
| 2. |
Determine the length of kennedy key required to transmit 1200N-m and allowable shear in the key is 40N/mm². The diameter of shaft and width of key can be taken as 40mm and 10mm respectively. |
| A. | 49mm |
| B. | 36mm |
| C. | 46mm |
| D. | 53mm |
| Answer» E. | |
| 3. |
A force 2P is acting on the double transverse fillet weld. Leg of weld is h and length l. Determine the shear stress in a plane inclined at θ with horizontal. |
| A. | PSinθ(Sinθ+Cosθ)/hl |
| B. | P(Sinθ+Cosθ)/hl |
| C. | Pcosθ(Sinθ+Cosθ)/hl |
| D. | None of the listed |
| Answer» B. P(Sinθ+Cosθ)/hl | |
| 4. |
A___________INTEGRITY_CONSTRAINT_REQUIRES_THAT_THE_VALUES_APPEARING_IN_SPECIFIED_ATTRIBUTES_OF_ANY_TUPLE_IN_THE_REFERENCING_RELATION_ALSO_APPEAR_IN_SPECIFIED_ATTRIBUTES_OF_AT_LEAST_ONE_TUPLE_IN_THE_REFERENCED_RELATION.?$ |
| A. | Referential |
| B. | Referencing |
| C. | Specific |
| D. | Primary |
| Answer» B. Referencing | |
| 5. |
SPLINES_ARE_KEYS.?$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
THE________IS_THE_ONE_IN_WHICH_THE_PRIMARY_KEY_OF_ONE_RELATION_IS_USED_AS_A_NORMAL_ATTRIBUTE_IN_ANOTHER_RELATION.?$ |
| A. | Referential relation |
| B. | Referencing relation |
| C. | Referenced relation |
| D. | Referred relation |
| Answer» D. Referred relation | |
| 7. |
Involute_splines_have_stub_teeth_with_a_pressure_angle_of____$ |
| A. | 30 |
| B. | 45 |
| C. | 60 |
| D. | Can’t be determined |
| Answer» C. 60 | |
| 8. |
Determine the length of kennedy key required to transmit 1200N-m and allowable shear in the key is 40N/mm². The diameter of shaft and width of key can be taken as 40mm and 10mm respectively?# |
| A. | 49mm |
| B. | 36mm |
| C. | 46mm |
| D. | 53mm |
| Answer» E. | |
| 9. |
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is calle? |
| A. | Referential relation |
| B. | Referencing relation |
| C. | Referenced relation |
| D. | Referred relation |
| Answer» C. Referenced relation | |
| 10. |
Woodruff key permits _____ movement b/w shaft and the hub. |
| A. | Axial |
| B. | Radial |
| C. | Eccentric |
| D. | None of the listed |
| Answer» C. Eccentric | |
| 11. |
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation. |
| A. | Candidate |
| B. | Primary |
| C. | Super |
| D. | Sub |
| Answer» C. Super | |
| 12. |
The main advantage of sunk key is that it is a _____ drive. |
| A. | Positive |
| B. | Negative |
| C. | Neutral |
| D. | None of the listed |
| Answer» B. Negative | |
| 13. |
Saddle key is more suitable than sunk key for heavy duty applications. |
| A. | True |
| B. | False |
| Answer» C. | |
| 14. |
Which one of the following attribute can be taken as a primary key? |
| A. | Name |
| B. | Street |
| C. | Id |
| D. | Department |
| Answer» D. Department | |
| 15. |
Hollow saddle key is superior to flat saddle key as far as power transmitting capability is concerned. |
| A. | True |
| B. | False |
| Answer» C. | |
| 16. |
A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. |
| A. | Rows |
| B. | Key |
| C. | Attribute |
| D. | Fields |
| Answer» C. Attribute | |
| 17. |
A sunk key fits in the keyway of the _____ only. |
| A. | Hub |
| B. | Sleeve |
| C. | Both hub and sleeve |
| D. | Neither hub nor sleeve |
| Answer» B. Sleeve | |
| 18. |
The subset of a super key is a candidate key under what condition? |
| A. | No proper subset is a super key |
| B. | All subsets are super keys |
| C. | Subset is a super key |
| D. | Each subset is a super key |
| Answer» B. All subsets are super keys | |
| 19. |
Maximum shear stress in transverse fillet weld of leg h and length l is |
| A. | P/hl |
| B. | 1.21P/hl |
| C. | P/1.21hl |
| D. | None of the listed |
| Answer» C. P/1.21hl | |
| 20. |
Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key? |
| A. | NAME |
| B. | ID |
| C. | CITY |
| D. | CITY, ID |
| Answer» C. CITY | |
| 21. |
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record? |
| A. | Candidate key |
| B. | Sub key |
| C. | Super key |
| D. | Foreign key |
| Answer» D. Foreign key | |