MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 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. |
The option in mysqlshow to show information about indexes in a table is _________ |
| A. | –no-data |
| B. | –indexes |
| C. | –keys |
| D. | –flag |
| Answer» D. –flag | |
| 2. |
The command which lists databases managed by the server is _____________ |
| A. | mysqld |
| B. | mysqlshow |
| C. | mysqllist |
| D. | mysqldb |
| Answer» C. mysqllist | |
| 3. |
THE_COMMAND_WHICH_LISTS_DATABASES_MANAGED_BY_THE_SERVER_IS______________?$ |
| A. | mysqld |
| B. | mysqlshow |
| C. | mysqllist |
| D. | mysqldb |
| Answer» C. mysqllist | |
| 4. |
The_option_in_mysqlshow_to_show_information_about_indexes_in_a_table_is__________$ |
| A. | –no-data |
| B. | –indexes |
| C. | –keys |
| D. | –flag |
| Answer» D. ‚Äö√Ñ√∂‚àö√ë‚àö¬®flag | |
| 5. |
Which table stores information about the threads executing within the server? |
| A. | PROCESS |
| B. | PROCESSLIST |
| C. | LIST |
| D. | THREADSLIST |
| Answer» C. LIST | |
| 6. |
INFORMATION_SCHEMA is more portable than SHOW statements. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins? |
| A. | ENGINES, PLUGINS |
| B. | FILES, PLUGINS |
| C. | ENGINES, FILES |
| D. | PLUGINS, STATISTICS |
| Answer» B. FILES, PLUGINS | |
| 8. |
The information about table index characteristics is stored in which table of INFORMATION_SCHEMA? |
| A. | FILES |
| B. | STATISTICS |
| C. | SCHEMATA |
| D. | VIEWS |
| Answer» C. SCHEMATA | |
| 9. |
Which disk data does FILES table in INFORMATION_SCHEMA store? |
| A. | NDB |
| B. | NBD |
| C. | NBK |
| D. | NCD |
| Answer» B. NBD | |
| 10. |
INFORMATION_SCHEMA is based on the SQL standard. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
Which statement is used to determine the storage engine for individual tables? |
| A. | SHOW STATUS OF TABLE |
| B. | SHOW STATUS TABLE |
| C. | SHOW TABLE STATUS |
| D. | SHOW DEFAULT STATUS |
| Answer» D. SHOW DEFAULT STATUS | |
| 12. |
The general term for information about databases and the objects in MySQL is _________ |
| A. | datum |
| B. | info |
| C. | record |
| D. | metadata |
| Answer» E. | |