Q. For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is

  • (A) 1
  • (B) 2
  • (C) 3
  • (D) 4
πŸ’¬ Discuss
βœ… Correct Answer: (D) 4
Explanation: in mysql, for the hash indexes, a hash function is applied to each of the column values. the resulting hash values are stored in the index and used to perform lookups on it.

Explanation by: Mr. Dubey
in mysql, for the hash indexes, a hash function is applied to each of the column values. the resulting hash values are stored in the index and used to perform lookups on it.

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
214
Total Visits
πŸ“½οΈ
3 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
91%
Success Rate