Test your skills: Building MongoDB find() Queries

You are creating a find statement to retrieve data from the customers collection. You want to return all documents for customers born after December 31, 1989. The collection’s dob field contains each customer’s date of birth.

Which search condition should you include in the statement’s query argument?

You are creating a find statement to retrieve data from the customers collection. You want to return all documents for customers that use Android phones.

The phone type is listed in the device field, but the references to Android phones might be inconsistent. The only certainty is that the term android is included somewhere in the device value.

Which search condition should you include in the statement’s query argument?

You are creating a find statement to retrieve data from the customers collection. You want to return the first and last names of all customers with a Premium package.

Which query and projection arguments should you pass to the find method?

You are creating a query in Visual Query Builder to retrieve data from the customers collection. You want to define a search condition that limits the results to customers in the states of Delaware, Illinois, and Hawaii.

You start by adding a search condition to the Query section. You then select the address.state field option and the in operator option from the drop-down lists.

Which string should you type into the text box?

You are creating a query in Visual Query Builder to retrieve data from the customers collection. You want to sort the query results by the values in the last field. How do you define the sort condition?

You create a query in Visual Query Builder to retrieve data from the customers collection. You run the query and view the results. You now want to edit the query in IntelliShell.

What's the easiest way to transfer the query from Visual Query Builder to the IntelliShell editor?