gs gs113 Using SQL to Manage Data - Using Full Text Searches - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Using SQL to Manage Data. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: In which mode of search is the search string parsed into words and the search looks for rows?
Natural language
Boolean mode
Query expansion
Cross mode
Question 2: The indicator of presence or absence of a word in search is used in which mode?
Natural language
Boolean mode
Query expansion
Cross mode
Question 3: Which search mode uses natural language search as a subroutine?
Natural language
Boolean mode
Query expansion
Cross mode
Question 4: FULLTEXT indexes can be created only for ____________
MyISAM
InnoDB
MEMORY
TRANSITION
Question 6: Which keyword is used to search through natural language fulltext?
MATCH
AGAINST
SEARCH
FIND
Question 7: What is xyz in the following MySQL statement?
SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');
column name
table name
search string
database name
Question 8: What is abc in the following MySQL statement?
SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');
column name
table name
search string
database name
Question 10: Which parameter determines the shortest words to index in FULLTEXT indexes?
ft_min_word_len
ft_min_len_word
ft_word_min_len
ft_word_len_word
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
