An index purports to speed data retrieval. you, therefore, index every attribute in each table. select the likely consequence.

a. you optimize data retrieval by using a where statement in your select query.

b. data entry slows as every insert , update, or delete statement must also update every index.

c. data retrieval on the gender column is optimized

d. this technique eliminates the need for a primary key

b. data entry slows as every INSERT , UPDATE, or DELETE statement must also update every index.

Explanation:

This process help to improve the speed of get data , it takes each element in the indexed column and save the location to get faster the data. But if you index every attribute in a table it going to take a lot of time locating each column in the respective index in each query(update, delete and insert). For that reason is necesary be carefull with this process and only put index in the relevant columns