Explanation:In MongoDB, sort operations can obtain the sort order by retrieving documents based on the ordering in an index. 2. Point out the wrong statement :
A. The query scans the index and the collection
B. An index supports a query when the index contains all the fields scanned by the query
C. Creating indexes that support queries results in greatly increased query performance
D. None of the mentioned
Answer:A
Explanation:In MongoDB, sort operations can obtain the sort order by retrieving documents based on the ordering in an index. 2. Point out the wrong statement :
A. The query scans the index and the collection B. An index supports a query when the index contains all the fields scanned by the query C. Creating indexes that support queries results in greatly increased query performance D. None of the mentioned
Explanation:The query scans the index and not the collection. 3. A prefix of a _______ index is a subset that consists of one or more keys at the start of the index key pattern.