Explanation:MongoDB will use the compound index for both queries. 6. An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition.
A. predicate
B. selection
C. equality
D. None of the mentioned
Answer:A
Explanation:MongoDB will use the compound index for both queries. 6. An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition.
A. predicate B. selection C. equality D. None of the mentioned
Explanation:Query must include equality conditions on all the prefix keys that precede the sort keys. 7. __________ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation.