Question
a.
The query scans the index and not the collection
b.
If overall selectivity is high, and if MongoDB must read a number of documents to return results, then some queries may perform faster without indexes
c.
A better strategy, depending on your queries, would be to create a compound index that includes the high-selectivity field and another field
d.
None of the mentioned
Posted under MongoDB
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. __________ query calculates distances using flat (planar) geometry.
View solution
Q. ________ is the ability of a query to narrow results using the index.
View solution
Q. Indexes do not have to fit entirely into ______ in all cases.
View solution
Q. __________ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation.
View solution
Q. An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition.
View solution
Q. Point out the correct statement.
View solution
Q. Sort operations that do not use an index will abort when they use _______ megabytes of memory.
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. Point out the wrong statement.
View solution
Q. _________ operations that use an index often have better performance than those that do not use an index.
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. The default weight is ____ for the indexed fields.
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 name for the index consists of each indexed field name concatenated with _______
View solution
Q. To use a field with a name other than language, include the ________ option when creating the index.
View solution
Q. Point out the correct statement.
View solution
Q. If a collection contains documents or embedded documents that are in different languages, include a field named _______ in the documents.
View solution
Q. The default language for the indexed data is ________
View solution
Q. Point out the wrong statement.
View solution
Q. When creating a text index on multiple fields, you can specify the individual fields or you can use wildcard specifier ______
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MongoDB? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
