Explanation:For sharded collections, explain returns the core query planner and server information for each accessed shard in the shards field 5. Point out the wrong statement :
A. If MongoDB can use an index scan to obtain the requested sort order, the result will not include a SORT stage
B. In previous versions of MongoDB, cursor.explain() returned the scanAndOrder field to specify whether MongoDB could use the index order to return sorted results
C. If MongoDB uses indexes for an $and expression, the result will include the AND stage with an inputStages array that details the replicata sets
D. None of the mentioned
Answer:A
Explanation:For sharded collections, explain returns the core query planner and server information for each accessed shard in the shards field 5. Point out the wrong statement :
A. If MongoDB can use an index scan to obtain the requested sort order, the result will not include a SORT stage B. In previous versions of MongoDB, cursor.explain() returned the scanAndOrder field to specify whether MongoDB could use the index order to return sorted results C. If MongoDB uses indexes for an $and expression, the result will include the AND stage with an inputStages array that details the replicata sets D. None of the mentioned
Explanation:If MongoDB uses indexes for an $or expression, the result will include the OR stage with an inputStages array that details the indexes 6. If the query planner selects a collection scan, the explain result includes a _________ stage.