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. |
An embedded application includes the server side and client side. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
Multiple statement execution is not enabled by default. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
What is the embedded server library containing the MySQL server linkable into applications? |
| A. | libmysqla |
| B. | libmysqlb |
| C. | libmysqlc |
| D. | libmysqld |
| Answer» E. | |
| 4. |
MULTIPLE_STATEMENT_EXECUTION_IS_NOT_ENABLED_BY_DEFAULT.?$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
An_embedded_application_includes_the_server_side_and_client_side.$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
What is the embedded server library when building from source enabled by? |
| A. | –with-embedded-server |
| B. | –with-server-embedded |
| C. | –with-embedded-library |
| D. | –with-library-embedded |
| Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®with-server-embedded | |
| 7. |
What is exec_stmt_ssl written in? |
| A. | C++ |
| B. | C |
| C. | Python |
| D. | Perl |
| Answer» C. Python | |
| 8. |
Encrypted connections can be established using ______________ |
| A. | exec_stmt_ssl |
| B. | exec_ssl_stmt |
| C. | exec_stmnt_ssl |
| D. | exec_ssl_stmnt |
| Answer» B. exec_ssl_stmt | |
| 9. |
Which data directory subdirectory corresponds to the nbdinfo database? |
| A. | mysql |
| B. | performance_schema |
| C. | sys |
| D. | nbdinfo |
| Answer» C. sys | |
| 10. |
Which data directory subdirectory provides the information used to inspect the internal execution of the server at runtime. |
| A. | mysql |
| B. | performance_schema |
| C. | sys |
| D. | nbdinfo |
| Answer» C. sys | |
| 11. |
The datadir variable value can be seen using ______________ |
| A. | SHOW VARIABLES |
| B. | DISP VARIABLES |
| C. | CONNECT VARIABLES |
| D. | SHOW VARIABLE |
| Answer» B. DISP VARIABLES | |
| 12. |
The option that specifies the data directory location at server startup is ______________ |
| A. | –data |
| B. | –data_dir |
| C. | –data-dir |
| D. | –datadir |
| Answer» E. | |