Which of the following is able to use the index for the query?

Posted by: Pdfprep Category: C100DBA Tags: , ,

You have the following index on the toys collection:

{

"manufacturer" : 1,

"name" : 1,

"date" : -1

}

Which of the following is able to use the index for the query? Check all that apply.
A . db.toys.find( { name : "Big Rig Truck", date : "2013-02-01", manufacturer : "Tanko"
B . db.toys.find( { manufacturer : "Matteo", name : "Barbara", date : "2014-07-02" } )
C . db.toys.find( { date : "2015-03-01", manufacturer : "Loggo", name : "Brick Set" } )

Answer: A,B,C

Leave a Reply

Your email address will not be published.