Q. _________ operations that use an index often have better performance than those that do not use an index.

View solution

Q. Point out the wrong statement.

View solution

Q. A prefix of a _______ index is a subset that consists of one or more keys at the start of the index key pattern.

View solution

Q. Sort operations that do not use an index will abort when they use _______ megabytes of memory.

View solution

Q. Point out the correct statement.

View solution

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