gs gs113 Query Optimization - MySQL Query Optimizer - 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 Query Optimization. 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: To check how MySQL would execute a SELECT query, which statement is used?
TELL
SHOW
DISPLAY
EXPLAIN
Question 2: To perform analysis of key values by the server, the statement used is __________
ANALYZE KEYS
ANALYZE TABLE
PERFORM ANALYSIS
PERFORM TABLE ANALYSIS
Question 3: Which statement is used to verify optimizer operation?
ANALYZE
VERIFY
EXPLAIN
SHOW
Question 4: Which statement is used to force the optimizer to use tables in a particular order?
FORCE INDEX
USE INDEX
IGNORE INDEX
STRAIGHT_JOIN
Question 5: Which of these comparisons is slowest?
INT/INT
INT/BIGINT
BIGINT/BIGINT
All are of same speed
Question 6: Which of the following WHERE clauses are faster?
1. WHERE col * 3 < 9 2. WHERE col < 9 / 3
1
2
same speed
dependent on operating system
Question 8: Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
optimizer_prune_level
optimizer_search_depth
optimizer_search
optimizer_prune
Question 9: Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?
optimizer_prune_level
optimizer_search_depth
optimizer_search
optimizer_prune
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
