What is the purpose of index in sql server


To enhance the query performance


To provide an index to a record


To perform fast searches


All of the mentioned

Posted under Indexing and Hashing DBMS

Answer: (d).All of the mentioned

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is the purpose of index in sql server

Similar Questions

Discover Related MCQs

Q. How many types of indexes are there in sql server?

Q. How non clustered index point to the data?

Q. Which one is true about clustered index?

Q. What is true about indexes?

Q. Does index take space in the disk ?

Q. What are composite indexes ?

Q. In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.

Q. A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.

Q. A(n) _________ can be used to preserve the integrity of a document or a message.

Q. A hash function must meet ________ criteria.

Q. Index which has an entry for some of key value is classified as

Q. Primary indexes, secondary indexes and cluster indexes are all types of

Q. In multilevel indexes, primary index created for its first level is classified as

Q. Indexes which specifies address of records on disk with a physical pointer are classified as

Q. Example of non dense index is

Q. In data file, first record of any of block is called

Q. File which has secondary index for its every field is classified as

Q. First field in primary index having same data type as in ordering field is considered as

Q. In multilevel indexes, primary index created for its second level is classified as

Q. The method of access which uses key transformation is known as