Cognizant Interview Question

Sql indexing situation based question.