Arrays and Nested Objects Queries Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering SQL Language for NoSQL API

What you'll be asked

  1. Which SQL operator is typically used to filter documents where an array field contains a specific value?
  2. When querying a nested object field named 'address' with a sub-property 'city', what is the standard dot-notation syntax to access the city?
  3. If you have a document with an array of objects called 'tags', how do you project only the 'name' property from each object in the array?
  4. Which function is used to determine the number of elements currently stored in an array field?
  5. You need to find documents where at least one element in the 'orders' array has a 'total' greater than 100. Which approach is most efficient?

Answers and explanations come after you submit.