$elemMatch for complex array queries in MongoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

Find documents with a matching array element using $elemMatch

Given a collection products where each document has an array field reviews with objects containing rating and comment, which query returns products that have at least one review with a rating greater than 4 and a comment containing the word 'excellent'?

MongoDB

db.products.find({ reviews: { $elemMatch: { rating: { $gt: 4 }, comment: /excellent/i } } })

A db.products.find({ reviews: { $elemMatch: { rating: { $gte: 4 }, comment: /excellent/ } } })

B db.products.find({ reviews: { rating: { $gt: 4 }, comment: /excellent/i } })

C db.products.find({ reviews: { $elemMatch: { rating: 4, comment: 'excellent' } } })

D db.products.find({ reviews: { $elemMatch: { rating: { $gt: 4 }, comment: /excellent/i } } })

💡 Hint

Use $elemMatch to match multiple conditions on the same array element.

Option D correctly uses $elemMatch to find array elements where rating is greater than 4 and comment matches the regex 'excellent' case-insensitively. Option D is invalid because $elemMatch is missing. Option D looks for rating exactly 4 and comment exactly 'excellent' (case sensitive). Option D uses $gte 4 instead of $gt 4 and a regex without case-insensitive flag.

🧠 Conceptual

intermediate

Understanding $elemMatch behavior with multiple conditions

What does the $elemMatch operator do when used in a query on an array field?

A It matches documents where at least one array element satisfies all specified conditions inside $elemMatch.

B It matches documents where all array elements satisfy each condition separately.

C It matches documents where any array element satisfies at least one of the conditions inside $elemMatch.

D It matches documents where the array contains exactly one element.

💡 Hint

Think about how $elemMatch applies conditions to a single element.

$elemMatch matches documents where at least one element in the array meets all the conditions inside it. It does not require all elements to match, nor does it match if conditions are split across different elements.

📝 Syntax

advanced

Identify the syntax error in $elemMatch usage

Which of the following queries will cause a syntax error when using $elemMatch in MongoDB?

A db.collection.find({ items: { $elemMatch: { price: { $lt: 20 }, qty: { $gt: 5 } } } })

B db.collection.find({ items: { $elemMatch: { qty: { $gt: 5 } } } })

C db.collection.find({ items: { $elemMatch: price: { $lt: 20 }, qty: { $gt: 5 } } })

D db.collection.find({ items: { $elemMatch: { price: { $lt: 20 } } } })

💡 Hint

Check the brackets and object syntax inside $elemMatch.

Option C is missing curly braces around the object passed to $elemMatch, causing a syntax error. The others have correct syntax.

❓ optimization

advanced

Optimizing queries with $elemMatch on large arrays

When querying documents with large arrays, which approach using $elemMatch is generally more efficient?

A Use $elemMatch to combine multiple conditions on the same array element instead of separate queries for each condition.

B Use multiple $elemMatch operators on the same array field for each condition separately.

C Avoid $elemMatch and use $or with separate conditions on the array field.

D Use $elemMatch only with a single condition to reduce complexity.

💡 Hint

Think about how MongoDB can use indexes and reduce scanning.

Combining multiple conditions inside a single $elemMatch allows MongoDB to efficiently find array elements matching all conditions at once, improving performance especially on large arrays. Using multiple $elemMatch or $or can cause more scanning.

🔧 Debug

expert

Why does this $elemMatch query return no results?

Consider the collection orders with documents containing an array items. Each item has productId and quantity. The query below returns no documents, but you expect some matches:

db.orders.find({ items: { $elemMatch: { productId: 123, quantity: { $gt: 10 } } } })

What is the most likely reason?

A The quantity field is missing in all array elements.

B No single array element has both productId 123 and quantity greater than 10; conditions are split across elements.

C The $elemMatch operator cannot be used with numeric comparisons.

D The productId field is stored as a string, but the query uses a number.

💡 Hint

Remember $elemMatch matches conditions on the same element, not across elements.

Option B is correct because $elemMatch requires all conditions to be true on the same array element. If productId 123 is in one element and quantity > 10 in another, no match occurs. Option B could cause no matches but is less likely if data types are consistent. Option B is false; $elemMatch supports numeric comparisons. Option B would cause no matches but is less common.