MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
To reactivate indexes the command used is _________________ |
| A. | DISABLE KEYS |
| B. | DISABLE INDEXES |
| C. | ENABLE KEYS |
| D. | ENABLE INDEXES |
| Answer» D. ENABLE INDEXES | |
| 2. |
TO enable the compressed client/server protocol the option is _________________ |
| A. | –enable |
| B. | –compress |
| C. | –reduce |
| D. | –restrict |
| Answer» C. –reduce | |
| 3. |
The option which delays index flushing for slave server is _________________ |
| A. | –delay-write-key=ALL |
| B. | –delay-key-write=ALL |
| C. | –key-write-delay=NONE |
| D. | –key-delay-write=NONE |
| Answer» C. –key-write-delay=NONE | |
| 4. |
Which option turns on the –extended-insert? |
| A. | –opt |
| B. | –opti |
| C. | –op |
| D. | –optimize |
| Answer» B. –opti | |
| 5. |
TO_ENABLE_THE_COMPRESSED_CLIENT/SERVER_PROTOCOL_THE_OPTION_IS__________________?$ |
| A. | –enable |
| B. | –compress |
| C. | –reduce |
| D. | –restrict |
| Answer» C. ‚Äö√Ñ√∂‚àö√ë‚àö¬®reduce | |
| 6. |
To_reactivate_indexes_the_command_used_is__________________$ |
| A. | DISABLE KEYS |
| B. | DISABLE INDEXES |
| C. | ENABLE KEYS |
| D. | ENABLE INDEXES |
| Answer» D. ENABLE INDEXES | |
| 7. |
The option which delays index flushing for slave server is ________________? |
| A. | –delay-write-key=ALL |
| B. | –delay-key-write=ALL |
| C. | –key-write-delay=NONE |
| D. | –key-delay-write=NONE |
| Answer» C. ‚Äö√Ñ√∂‚àö√ë‚àö¬®key-write-delay=NONE | |
| 8. |
Which option repairs MyISAM tables automatically after they open? |
| A. | –myisam-recover=FORCE |
| B. | –myisam-recover=STOP |
| C. | –recover-myisam=FORCE |
| D. | –recover-myisam=STOP |
| Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®myisam-recover=STOP | |
| 9. |
Which table option for MyISAM tables reduces index flushing? |
| A. | DELAY_KEY_WRITE |
| B. | DELAY_WRITE_KEY |
| C. | KEY_WRITE_DELAY |
| D. | WRITE_KEY_DELAY |
| Answer» B. DELAY_WRITE_KEY | |
| 10. |
Which option turns on the –extended-insert?$ |
| A. | –opt |
| B. | –opti |
| C. | –op |
| D. | –optimize |
| Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®opti | |
| 11. |
Without LOCAL, LOAD DATA is _________________ |
| A. | more efficient |
| B. | less efficient |
| C. | same speed |
| D. | arbitrary |
| Answer» B. less efficient | |
| 12. |
Which is more efficient? |
| A. | |
| B. | LOAD DATA |
| C. | INSERT |
| Answer» B. LOAD DATA | |
| 13. |
Loading is faster when a table has no indexes than when it is indexed. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
Bulk loading is less efficient than single row loading. |
| A. | True |
| B. | False |
| Answer» C. | |