MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 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. |
Which parameter determines the shortest words to index in FULLTEXT indexes? |
| A. | ft_min_word_len |
| B. | ft_min_len_word |
| C. | ft_word_min_len |
| D. | ft_word_len_word |
| Answer» B. ft_min_len_word | |
| 2. |
In Boolean search, results are sorted by relevance. |
| A. | True |
| B. | False |
| Answer» C. | |
| 3. |
column_name$ |
| A. | table name |
| B. | search string |
| C. | database name |
| Answer» B. search string | |
| 4. |
column nam? |
| A. | table name |
| B. | search string |
| C. | database name |
| Answer» B. search string | |
| 5. |
Which keyword is used to search through natural language fulltext? |
| A. | MATCH |
| B. | AGAINST |
| C. | SEARCH |
| D. | FIND |
| Answer» B. AGAINST | |
| 6. |
A FULLTEXT index cannot be created for multiple columns. |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
FULLTEXT indexes can be created only for ____________ |
| A. | MyISAM |
| B. | InnoDB |
| C. | MEMORY |
| D. | TRANSITION |
| Answer» B. InnoDB | |
| 8. |
Which search mode uses natural language search as a subroutine? |
| A. | Natural language |
| B. | Boolean mode |
| C. | Query expansion |
| D. | Cross mode |
| Answer» D. Cross mode | |
| 9. |
The indicator of presence or absence of a word in search is used in which mode? |
| A. | Natural language |
| B. | Boolean mode |
| C. | Query expansion |
| D. | Cross mode |
| Answer» C. Query expansion | |
| 10. |
In which mode of search is the search string parsed into words and the search looks for rows? |
| A. | Natural language |
| B. | Boolean mode |
| C. | Query expansion |
| D. | Cross mode |
| Answer» B. Boolean mode | |