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
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.
2.2k
0
Do you find this helpful?
21

Discussion

No comments yet