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

View solution

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

View solution

Q. Which of the following indexes are always sparse?

View solution

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

View solution

Q. Point out the wrong statement.

View solution

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.

View solution

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

View solution

Q. Point out the correct statement.

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Point out the wrong statement.

View solution

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

View solution

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

View solution

Q. Point out the correct statement.

View solution

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

View solution

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

View solution