Q. Point out the correct statement.

View solution

Q. To use a field with a name other than language, include the ________ option when creating the index.

View solution

Q. The default name for the index consists of each indexed field name concatenated with _______

View solution

Q. To avoid creating an index with a name that exceeds the index name length limit, you can pass the _____ option to the db.collection.createIndex() method.

View solution

Q. The default weight is ____ for the indexed fields.

View solution

Q. For a ______ index, the weight of an indexed field denotes the significance of the field relative to the other indexed fields in terms of the score.

View solution

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

View solution

Q. Point out the wrong statement.

View solution

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

View solution

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

View solution

Q. Point out the correct statement.

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Point out the wrong statement.

View solution

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

View solution

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

View solution

Q. Point out the correct statement.

View solution