Point out the correct statement.
(a) If an appropriate index exists for a query, MongoDB cannot use the index to limit the number of documents it must inspect
(b) Indexes support the efficient execution of queries in MongoDB
(c) The index stores the location of a specific field or set of fields, ordered by the value of the field
(d) None of the mentioned
This question was addressed to me during an online interview.
This intriguing question comes from Indexes In MongoDB topic in division Index/Indexing Concepts of MongoDB