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

Posted under MongoDB

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.