Explanation:To determine if MongoDB used index intersection, run explain(); the results of explain() will include either an AND_SORTED stage or an AND_HASH stage. 9. An index prefix is a subset of a______ index, consisting of one or more keys starting from the beginning of the index.
A. Hashed
B. Unique
C. sparse
D. compound
Answer:A
Explanation:To determine if MongoDB used index intersection, run explain(); the results of explain() will include either an AND_SORTED stage or an AND_HASH stage. 9. An index prefix is a subset of a______ index, consisting of one or more keys starting from the beginning of the index.
A. Hashed B. Unique C. sparse D. compound
Explanation:With index intersection, MongoDB can use an intersection of either the entire index or the index prefix. 10.Index __________ does not eliminate the need for creating compound indexes.