adplus-dvertising
frame-decoration

Question

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

a.

Select

b.

Update

c.

Delete

d.

Sort

Answer: (d).Sort

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Similar Questions

Discover Related MCQs

Q. Point out the wrong statement.

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.