MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 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. |
A FULLTEXT index can be created for multiple columns. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
For what can the FULLTEXT indexes be created for? |
| A. | MyISAM |
| B. | InnoDB |
| C. | MEMORY |
| D. | TRANSITION |
| Answer» B. InnoDB | |
| 3. |
The search mode that uses natural language search as a subroutine is ____________ |
| A. | Natural language |
| B. | Boolean mode |
| C. | Query expansion |
| D. | Cross mode |
| Answer» D. Cross mode | |
| 4. |
The keyword used with UNION that retains duplicate rows is ___________ |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» B. NARROW | |
| 5. |
The largest value to which the variable ‘max_allowed_packet’ can be set is ______________ |
| A. | 1GB |
| B. | 2GB |
| C. | 4GB |
| D. | 8GB |
| Answer» B. 2GB | |
| 6. |
THE_SEARCH_MODE_THAT_USES_NATURAL_LANGUAGE_SEARCH_AS_A_SUBROUTINE_IS_____________?$ |
| A. | Natural language |
| B. | Boolean mode |
| C. | Query expansion |
| D. | Cross mode |
| Answer» B. Boolean mode | |
| 7. |
For_what_can_the_FULLTEXT_indexes_be_created_for?$ |
| A. | MyISAM |
| B. | InnoDB |
| C. | MEMORY |
| D. | TRANSITION |
| Answer» B. InnoDB | |
| 8. |
The keyword used with UNION that retains duplicate rows is __________? |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» D. DISTINCT | |
| 9. |
The keyword used with UNION that does not retain duplicate rows is _____________ |
| A. | ALL |
| B. | NARROW |
| C. | STRICT |
| D. | DISTINCT |
| Answer» B. NARROW | |
| 10. |
Increasing the value of which system variable enables mysqld to keep more tables open simultaneously? |
| A. | table_cache |
| B. | max_connect |
| C. | delayed_queue_size |
| D. | max_allowed_packet |
| Answer» B. max_connect | |
| 11. |
The largest value to which the variable ‘max_allowed_packet’ can be set is ______________$ |
| A. | 1GB |
| B. | 2GB |
| C. | 4GB |
| D. | 8GB |
| Answer» B. 2GB | |
| 12. |
Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table? |
| A. | fast_queue_size |
| B. | general_queue_size |
| C. | slow_queue_size |
| D. | delayed_queue_size |
| Answer» E. | |
| 13. |
Which mode exists at both global level and session-specific level? |
| A. | sql_mode |
| B. | key_buffer_size |
| C. | server_mode |
| D. | query_mode |
| Answer» B. key_buffer_size | |