a) plan b) shape c) stats d) all of the mentioned Answer: b Explanation: Index filters determine ...
View QuestionA ________ query plan has returned a threshold number of matching results.
a) execution b) unordered c) ordered d) none of the mentioned Answer: c Explanation: An ordered query ...
View Question_________ is used to view statistics about the query plan for a given query.
a) db.explain() b) cursor.explain() c) cursor.explainstats() d) all of the mentioned Answer: b Explanation: This information can ...
View QuestionThe update() method uses the _______ command, which uses the default write concern.
a) find b) read c) update d) modify Answer: c Explanation: The update() method returns an object ...
View Question_____ can modify specific fields of an existing document or documents or replace an existing document entirely, depending on the update parameter.
a) modify() b) update() c) find() d) none of the mentioned Answer: b Explanation: By default, ...
View QuestionPoint out the correct statement.
a) An equality match on the unique _id field is less selective as it can match at most ...
View QuestionThe ________ message is used to update a document in a collection.
a) UPDATE b) OP_UPDATE c) OP_UPDATES d) All of the mentioned Answer: b Explanation: Only the OP_QUERY ...
View Question___________ is used to determine whether a query is a covered query.
a) explainstats() b) explain() c) explainall() d) all of the mentioned Answer: b Explanation: db.collection.explain() provides information ...
View QuestionPoint out the wrong statement.
a) Query selectivity refers to how well the query predicate excludes or filters out documents in a collection
View QuestionIndexes are typically available in ______ or located sequentially on disk.
a) RAM b) ROM c) CMOS d) None of the mentioned Answer: a Explanation: Querying only the index can be much faster than ...
View Question