Database MCQ Set 1 1. What is the purpose of index in sql server a) To enhance the query performance b) To provide an index to a record c) To perform fast searches d) All of the mentioned AnswerAnswer: d [Reason:] A database index is a data structure that improves the speed of data retrieval…