1.

Point out the wrong statement.(a) Query selectivity refers to how well the query predicate excludes or filters out documents in a collection(b) Query selectivity can determine whether or not queries can use indexes effectively or even use indexes at all(c) More selective queries match a larger percentage of documents(d) All of the mentionedThe question was posed to me in final exam.My question comes from Analyze Query Performance in division MongoDB CRUD Concepts and Operation of MongoDB

Answer»

The CORRECT option is (C) More SELECTIVE queries match a larger percentage of DOCUMENTS

Explanation: More selective queries match a smaller percentage of documents.



Discussion

No Comment Found

Related InterviewSolutions