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

Solution (By Examveda Team)

This question is about hash indexes in MySQL.

A hash index is a special kind of index that helps MySQL find data very quickly. It works by using a hash function to create a unique "fingerprint" for each row in your table.

Think of it like this: imagine you have a book with lots of pages. A hash index is like creating a special index at the back of the book that tells you exactly where each page is. Instead of having to search through every page, you can just look up the page number in the index and jump right to it.

The hash function is the magic that creates those unique "fingerprints" for each row. In MySQL, this hash function is applied to one column of your table. This column is chosen carefully to help MySQL find the data you need faster.

So, the answer is Option A: 1.

Even though your table might have 4 columns, only one column is used for the hash index.