a) Are those which are composed by database for its internal use
b) A composite index is a combination of index on 2 or more columns
c) Composite index can never be created
d) None of the mentioned
Answer: b
Explanation: A composite index is an index on two or more columns of a table.
Related Posts
A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
If an index is _________________ the metadata and statistics continue to exists
Does index take space in the disk?:
What is true about indexes?
Which one is true about clustered index?
How non clustered index point to the data?
Join The Discussion