Explore topic-wise MCQs in Structured Query Language (SQL).

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
Discussion
2.

In Boolean search, results are sorted by relevance.

A. True
B. False
Answer» C.
Discussion
3.

column_name$

A. table name
B. search string
C. database name
Answer» B. search string
Discussion
4.

column nam?

A. table name
B. search string
C. database name
Answer» B. search string
Discussion
5.

Which keyword is used to search through natural language fulltext?

A. MATCH
B. AGAINST
C. SEARCH
D. FIND
Answer» B. AGAINST
Discussion
6.

A FULLTEXT index cannot be created for multiple columns.

A. True
B. False
Answer» C.
Discussion
7.

FULLTEXT indexes can be created only for ____________

A. MyISAM
B. InnoDB
C. MEMORY
D. TRANSITION
Answer» B. InnoDB
Discussion
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
Discussion
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
Discussion
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
Discussion