Question
a.
If you only ever query on a single key in a given collection, then you need to create just multikey index for that collection
b.
If you sometimes query on only one key and at other times query on that key combined with a second key, then creating a compound index is more efficient than creating a single-key index
c.
The choice between creating compound indexes that support your queries or relying on index intersection is independent of specifics of your system
d.
None of the mentioned
Posted under MongoDB
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Point out the correct statement.
Similar Questions
Discover Related MCQs
Q. An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition.
View solution
Q. __________ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation.
View solution
Q. Indexes do not have to fit entirely into ______ in all cases.
View solution
Q. ________ is the ability of a query to narrow results using the index.
View solution
Q. __________ query calculates distances using flat (planar) geometry.
View solution
Q. Point out the wrong statement.
View solution
Q. _________ defines a circle for a geospatial query that uses spherical geometry.
View solution
Q. When used with the $box operator, _________ returns documents based on grid coordinates and does not query for GeoJSON shapes.
View solution
Q. Point out the correct statement.
View solution
Q. Applications can use _________ without having a geospatial index.
View solution
Q. _________ specifies a polygon for a geospatial $geoWithin query on legacy coordinate pairs.
View solution
Q. Only the ______ geospatial index supports the $polygon operator.
View solution
Q. ________ returns a document only once for a geospatial query even if the document matches the query multiple times.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MongoDB? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!