adplus-dvertising
frame-decoration

Question

Point out the correct statement.

a.

An equality match on the unique _id field is less selective as it can match at most one document

b.

The selectivity of regular expressions depends on the expressions themselves

c.

Less selective queries can use indexes effectively or even at all

d.

All of the mentioned

Answer: (b).The selectivity of regular expressions depends on the expressions themselves

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 correct statement.

Similar Questions

Discover Related MCQs

Q. The ________ message is used to update a document in a collection.

Q. ___________ is used to determine whether a query is a covered query.

Q. Point out the wrong statement.

Q. Indexes are typically available in ______ or located sequentially on disk.

Q. With a receipt acknowledged write concern, the _________confirms that it received the write operation and applied the change to the in-memory view of data.

Q. With an __________ write concern, MongoDB does not acknowledge the receipt of write operations.

Q. MongoDB does not ___________ modifications made before the wtimeout interval expired.

Q. Clients can set a __________ value as part of a replica acknowledged write concern.

Q. _____________ is used to control mongod commits in the journal.

Q. Point out the wrong statement.

Q. The mongo shell and the MongoDB drivers use __________ as the default write concern.

Q. When inserts, updates and deletes have a _________ write concern, write operations return quickly.

Q. Point out the correct statement.

Q. ___________ concern describes the guarantee that MongoDB provides when reporting on the success of a write operation.

Q. An index cannot cover a query on a _______ collection when run against a mongos if the index does not contain the shard key.

Q. Which of the following operator is not very selective?

Q. ____________ is a client or database-generated identifier that uniquely identifies this message.

Q. The __________ method returns a document that includes a metrics field.

Q. ______________ specifies the number of documents to return in each batch of the response from the MongoDB instance.

Q. Point out the wrong statement.