adplus-dvertising
frame-decoration

Question

You can combine the ________ constraint with the sparse index to filter these null values from the unique index and avoid the error.

a.

Hashed

b.

Unique

c.

Sparse

d.

Compound

Posted under MongoDB

Answer: (c).Sparse

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. You can combine the ________ constraint with the sparse index to filter these null values from the unique index and avoid the error.

Similar Questions

Discover Related MCQs

Q. You may not specify a unique constraint on a ______ index.

Q. Which of the following indexes are always sparse?

Q. To modify an existing index, you cannot just re-issue the _________ method with the updated specification of the index.

Q. Point out the wrong statement.

Q. If you need to rebuild indexes for a collection you can use the _________ method to rebuild all indexes on a collection in a single operation.

Q. To terminate an ongoing index build, use the __________ method in the mongo shell.

Q. Point out the correct statement.

Q. In the mongo shell, you can use the ______ method to return a list of the indexes on a collection.

Q. __________ views partial execution statistics collected during plan selection.

Q. The __________ operator constrains the results of a geospatial $near or $nearSphere query to the specified distance.

Q. To force MongoDB to use a particular index for a db.collection.________ operation, specify the index with the hint() method.

Q. Specify the ______ operator to the hint() method to prevent MongoDB from using any index.

Q. ___________ selects geometries that intersect with a GeoJSON geometry.

Q. Point out the wrong statement.

Q. _______ returns geospatial objects in proximity to a point.

Q. _________ specifies a geometry in GeoJSON format to geospatial query operators.

Q. Point out the correct statement.

Q. _________ returns geospatial objects in proximity to a point on a sphere. Requires a geospatial index.

Q. __________ specifies a minimum distance to limit the results of $near and $nearSphere queries.

Q. The _________ operator specifies a circle for a $geoWithin query.