Quiz will ask 20 randomly selected questions with allotted time of . You can take the quiz more than once. Once you submit the quiz, you can review how you have done, the correct the answers for each questions and the explanation for the correct the answer.
8 Modules
Which of the following statements about B-tree indexes in MySQL is true?
B-tree indexes are suitable for range queries.
B-tree indexes can only be used for equality comparisons.
B-tree indexes are not efficient for sorting operations.
B-tree indexes can be used for both equality and range queries.
What is a primary characteristic of Hash indexes in MySQL?
They are efficient for equality comparisons.
They can be used for range queries.
They require more disk space than B-tree indexes.
They are not suitable for large datasets.
Which type of index would you use for full-text search capabilities in MySQL?
B-tree index
Hash index
Full-text index
Spatial index
In which scenario would a B-tree index be less efficient compared to a Hash index?
When performing equality searches on a large dataset.
When performing range queries.
When the dataset has many unique values.
When the dataset has a lot of duplicate values.
What is a limitation of using Full-text indexes in MySQL?
They cannot be used on columns with NULL values.
They do not support boolean full-text searches.
They are only available for MyISAM storage engine.
They cannot be used for prefix searches.
8 Modules