adplus-dvertising
frame-decoration

Question

Point out the wrong statement.

a.

The query scans the index and the collection

b.

An index supports a query when the index contains all the fields scanned by the query

c.

Creating indexes that support queries results in greatly increased query performance

d.

None of the mentioned

Answer: (a).The query scans the index and the collection

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 wrong statement.

Similar Questions

Discover Related MCQs

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

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

Q. Point out the correct statement.

Q. An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition.

Q. __________ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation.

Q. Indexes do not have to fit entirely into ______ in all cases.

Q. ________ is the ability of a query to narrow results using the index.

Q. __________ query calculates distances using flat (planar) geometry.

Q. Point out the wrong statement.

Q. _________ defines a circle for a geospatial query that uses spherical geometry.

Q. When used with the $box operator, _________ returns documents based on grid coordinates and does not query for GeoJSON shapes.

Q. Point out the correct statement.

Q. Applications can use _________ without having a geospatial index.

Q. _________ specifies a polygon for a geospatial $geoWithin query on legacy coordinate pairs.

Q. Only the ______ geospatial index supports the $polygon operator.

Q. ________ returns a document only once for a geospatial query even if the document matches the query multiple times.