MySQL Query Optimizer MCQ

Test your knowledge with important MySQL Query Optimizer MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more MySQL Query Optimizer MCQs at Bissoy

• The optimizer_prune_level is set by default.
  ক

  True

  খ

  False
• 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
• 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
• Which of these comparisons is slowest?
  ক

  INT/INT

  খ

  INT/BIGINT

  গ

  BIGINT/BIGINT

  ঘ

  All are of same speed
• Which statement is used to force the optimizer to use tables in a particular order?
  ক

  FORCE INDEX

  খ

  USE INDEX

  গ

  IGNORE INDEX

  ঘ

  STRAIGHT_JOIN
• Which statement is used to verify optimizer operation?
  ক

  ANALYZE

  খ

  VERIFY

  গ

  EXPLAIN

  ঘ

  SHOW
• To perform analysis of key values by the server, the statement used is __________
  ক

  ANALYZE KEYS

  খ

  ANALYZE TABLE

  গ

  PERFORM ANALYSIS

  ঘ

  PERFORM TABLE ANALYSIS
• To check how MySQL would execute a SELECT query, which statement is used?
  ক

  TELL

  খ

  SHOW

  গ

  DISPLAY

  ঘ

  EXPLAIN