MongoDB
C100DBA · Question #107
C100DBA Question #107: Real Exam Question with Answer & Explanation
See the full explanation below for the reasoning.
Question
Below is a sample document in a given collection test. { a : 5, b : 3, c: 2, d : 1 > Given a compound index { a: 1, b:l, c:l, d:l}, Which of the below query will not use in-memory sorting? Select all valid.
Options
- Adb.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } )
- Bdb.test.find( { a: 5, b: 3 } ).sort( { a: 1} )
- Cdb.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )
- Ddb.test.find( { a: 5, b: 3 } ).sort( {c: 1 } )
Community Discussion
No community discussion yet for this question.