Use the following questions to help you review the material in this tutorial.
0 of 6 questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 6 questions answered correctly
Time has elapsed
You’ve finished the quiz! Move on to the next lesson or click on View Questions to review the quiz.
Well done! Move on to the next lesson or click on View Questions to review the quiz.
You create a SELECT
statement in SQL Query that retrieves data from the customers
collection. After you run the statement, you view the mongo shell find
statement that was generated for the SQL SELECT
statement.
Which SELECT
statement clause maps to the projection section in the find
statement?
You launch SQL Query and create the following SQL statement, which retrieves data from the customers collection:
select first, last, transactions from customers where address.state = 'Oregon' order by transactions desc;
After you run the SQL statement, you view the mongo
shell find
statement on the Query Code tab. Which expression appears in the sort section of the find
statement?
You are building an SQL statement in SQL Query that retrieves data from the customers
collection. You want to limit the results to customers born before the year 1980, based on the values in the dob
field.
Which clause should you include in your statement:
You launch SQL Query and create the following SQL statement, which retrieves data from the customers
collection:
select first, last from customers where interests like '%gaming%' order by last, first;
After you run the SQL statement, you view the mongo shell find
statement on the Query Code tab. Which expression appears in the query section of the find
statement?
You launch SQL Query and create the following SQL statement, which retrieves data from the customers
collection:
select address.state, sum(transactions) from customers group by address.state order by sum(transactions) desc;
After you run the SQL statement, you go to the Query Code tab. What type of mongo shell statement has SQL Query created?
You launch SQL Query and create an SQL statement that retrieves data from the customers
collection. After you run the statement, you go to the Query Code tab to view the mongo shell aggregate
statement.
You now want to edit the statement in the Aggregation Editor. Which step should you take?