Computer scienceSoftware development foundationsSQL and databasesDBMSMongoDBOperations and operators

Array query operations

<code>$size</code> operator

Report a typo

Suppose we have a collection named orders that contains documents with an array field items that lists the items ordered by each customer. Which of the following queries would return all the orders that have exactly two items?

Select one option from the list

db.orders.find({ items: { $elemMatch: { $gt: 1 } } })

db.orders.find({ items: { $size: { $eq: 2 } } })

db.orders.find({ items: { $all: ["item1", "item2"] } })

db.orders.find({ items: { $elemMatch: { $size: 2 } } })

Create a free account to access the full topic