MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 11 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. |
Installing more memory into the machine enables to configure larger values for cache server. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
INSTALLING_MORE_MEMORY_INTO_THE_MACHINE_ENABLES_TO_CONFIGURE_LARGER_VALUES_FOR_CACHE_SERVER.?$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
Which mode tells cache queries that begin with SELECT SQL_CACHE? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» D. 3 | |
| 4. |
Which mode tells not to cache query results? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» B. 1 | |
| 5. |
To determine whether query cache is supported by the server the variable is _________________ |
| A. | have_query_cache |
| B. | have_cache_query |
| C. | query_cache_have |
| D. | cache_query_have |
| Answer» B. have_cache_query | |
| 6. |
All queries can be cached. |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
The system variable to maintain InnoDB log buffer size is _________________ |
| A. | innodb_log_buffer_size |
| B. | innodb_buffer_log_size |
| C. | buffer_log_innodb_size |
| D. | log_buffer_innodb_size |
| Answer» B. innodb_buffer_log_size | |
| 8. |
In MySQL, the default size of the key buffer in MB is _________________ |
| A. | 4 |
| B. | 8 |
| C. | 16 |
| D. | 32 |
| Answer» C. 16 | |
| 9. |
Which status indicator assesses how effective the table cache is? |
| A. | Open_tables |
| B. | Opened_tables |
| C. | Close_tables |
| D. | Closed_tables |
| Answer» C. Close_tables | |
| 10. |
Which system variable controls the size of the table cache? |
| A. | table_cache |
| B. | cache_table |
| C. | open_cache |
| D. | cache_open |
| Answer» B. cache_table | |
| 11. |
Accessing data from which of these is faster? |
| A. | |
| B. | memory |
| C. | disk |
| Answer» B. memory | |