Using Indexing MCQ

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

• The slow query log is written as __________
  ক

  numbers

  খ

  text

  গ

  image

  ঘ

  graph
• The slow query log can be used to identify queries that may be performing badly.
  ক

  True

  খ

  False
• For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________
  ক

  1

  খ

  2

  গ

  3

  ঘ

  4
• If a column contains 7 values and 6 distinct values, the cardinality is __________
  ক

  7

  খ

  6

  গ

  13

  ঘ

  1
• In a single table (with 10 columns) join query the number of values needed to examine per column is __________
  ক

  1

  খ

  10

  গ

  0

  ঘ

  2
• The data rows of a MyISAM table are stored in __________
  ক

  data file

  খ

  index file

  গ

  log file

  ঘ

  error file
• The maximum number of indexes on MyISAM table is __________
  ক

  0

  খ

  1

  গ

  2

  ঘ

  more than 1
• Using indexes optimizes query performance.
  ক

  True

  খ

  False