Implicit AND with multiple conditions in MongoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

Find documents matching multiple conditions with implicit AND

Given a collection products with documents containing category and price, what is the output of this query?

db.products.find({ category: "books", price: { $lt: 20 } })

Assume the collection has:

{"category": "books", "price": 15}

{"category": "books", "price": 25}

{"category": "electronics", "price": 15}

MongoDB

db.products.find({ category: "books", price: { $lt: 20 } })

A [{"category": "books", "price": 25}]

B [{"category": "books", "price": 15}]

C [{"category": "electronics", "price": 15}]

D []

💡 Hint

Remember that specifying multiple fields in the query object means all conditions must be true.

The query matches documents where category is 'books' AND price is less than 20. Only the first document meets both conditions.

🧠 Conceptual

intermediate

Understanding implicit AND in MongoDB queries

Which statement best describes how MongoDB treats multiple conditions inside a single query object?

A MongoDB treats multiple conditions as an implicit OR, returning documents matching any condition.

B MongoDB ignores all but the first condition in the query object.

C MongoDB requires explicit $and operator to combine multiple conditions.

D MongoDB treats multiple conditions as an implicit AND, returning documents matching all conditions.

💡 Hint

Think about how multiple fields in a JSON object combine logically.

MongoDB combines multiple fields in a query object with an implicit AND, so all conditions must be true for a document to match.

📝 Syntax

advanced

Identify the invalid MongoDB query with multiple conditions

Which of the following MongoDB queries will cause a syntax error or fail to run?

A db.collection.find({ age: { $gt: 18 }, status: { $in: ["active", "pending"] } })

B db.collection.find({ $and: [{ age: { $gt: 18 } }, { status: "active" }] })

C db.collection.find({ age: { $gt: 18 }, $or: { status: "active" } })

D db.collection.find({ age: { $gt: 18 }, status: "active" })

💡 Hint

Check if the query mixes implicit AND with explicit $or incorrectly.

Option C is invalid because it mixes implicit AND with an $or operator at the same level without proper structure, causing a syntax error.

❓ optimization

advanced

Optimizing queries with multiple conditions

You want to find documents where status is "active" and score is greater than 50. Which query is more efficient in MongoDB?

A db.collection.find({ status: "active", score: { $gt: 50 } })

B db.collection.find({ $and: [{ status: "active" }, { score: { $gt: 50 } }] })

C db.collection.find({ $or: [{ status: "active" }, { score: { $gt: 50 } }] })

D db.collection.find({ status: { $eq: "active" }, score: { $gt: 50 } })

💡 Hint

Consider how MongoDB processes implicit AND vs explicit $and.

Option A uses implicit AND which MongoDB optimizes internally and is simpler and more efficient than explicit $and.

🔧 Debug

expert

Why does this MongoDB query return no results?

Given the collection users with documents:

{"name": "Alice", "age": 30, "city": "NY"}

{"name": "Bob", "age": 35, "city": "LA"}

Why does this query return no documents?

db.users.find({ age: { $gt: 20 }, age: { $lt: 28 } })

A Because MongoDB does not support multiple conditions on the same field in one query object; the second overwrites the first.

B Because no user has age greater than 20 and less than 28 at the same time.

C Because the query syntax is invalid and causes an error.

D Because the collection is empty.

💡 Hint

Check how JSON objects handle duplicate keys.

In JSON, duplicate keys are overwritten. The second 'age' condition replaces the first, so only { age: { $lt: 28 } } is applied, which matches users with age less than 28. The query returns no results because no user matches that condition. But the user expects both conditions combined.

Practice

1. In MongoDB, when you write a query with multiple conditions inside a single find() object, how are these conditions combined by default?

easy

A. They are combined with an implicit OR operator.

B. They cause a syntax error unless $and is used explicitly.

C. They are combined with an implicit AND operator.

D. They are ignored except for the first condition.

Solution

1. Step 1: Understand MongoDB query object behavior

   When multiple conditions are inside one query object, MongoDB treats them as AND conditions automatically.

2. Step 2: Recall the implicit AND rule

   You do not need to write $and explicitly; multiple fields in the query mean all must match.

3. Final Answer:

   They are combined with an implicit AND operator. -> Option C

4. Quick Check:

   Multiple conditions = implicit AND [OK]

Hint: Multiple conditions in one object mean AND automatically [OK]

Common Mistakes:

• Thinking multiple conditions mean OR by default
• Believing $and is always required
• Assuming only the first condition is checked

2. Which of the following is the correct syntax to find documents where age is 25 and status is "active" using implicit AND in MongoDB?

easy

A. db.collection.find({ age: 25 || status: "active" })

B. db.collection.find({ age: 25, status: "active" })

C. db.collection.find({ $and: [ { age: 25 }, { status: "active" } ] })

D. db.collection.find({ age: 25 && status: "active" })

Solution

1. Step 1: Recognize implicit AND syntax

   Using multiple fields inside one object automatically means AND, so { age: 25, status: "active" } is correct.

2. Step 2: Identify incorrect syntax

   Options A and D use JavaScript operators inside query object, which is invalid. db.collection.find({ $and: [ { age: 25 }, { status: "active" } ] }) is correct but explicit $and is not needed here.

3. Final Answer:

   db.collection.find({ age: 25, status: "active" }) -> Option B

4. Quick Check:

   Multiple fields in one object = implicit AND [OK]

Hint: Use multiple fields in one object for AND, no $and needed [OK]

Common Mistakes:

• Using JavaScript operators like && or || inside query object
• Always writing $and even when not needed
• Confusing OR and AND syntax

3. Given the collection documents:

{ name: "Alice", age: 30, city: "NY" }

{ name: "Bob", age: 25, city: "LA" }

{ name: "Carol", age: 30, city: "LA" }

What will be the result of this query?
db.collection.find({ age: 30, city: "LA" })

medium

A. []

B. [{ name: "Alice", age: 30, city: "NY" }, { name: "Carol", age: 30, city: "LA" }]

C. [{ name: "Bob", age: 25, city: "LA" }]

D. [{ name: "Carol", age: 30, city: "LA" }]

Solution

1. Step 1: Understand query conditions

   The query looks for documents where age is 30 AND city is "LA" simultaneously.

2. Step 2: Match documents

   Only Carol has age 30 and city "LA". Alice has age 30 but city "NY". Bob has city "LA" but age 25.

3. Final Answer:

   [{ name: "Carol", age: 30, city: "LA" }] -> Option D

4. Quick Check:

   Implicit AND filters to Carol only [OK]

Hint: All conditions must match; check each field carefully [OK]

Common Mistakes:

• Including documents that match only one condition
• Confusing OR with AND results
• Ignoring city or age condition

4. You wrote this query to find documents where status is "pending" and priority is "high":
db.tasks.find({ status: "pending", $and: [{ priority: "high" }] })
What is wrong with this query?

medium

A. The query will work fine and return correct results.

B. The $and array should contain multiple conditions, not just one.

C. Using $and inside the same object with other fields causes a syntax error.

D. You cannot mix implicit AND and explicit $and in the same query object.

Solution

1. Step 1: Analyze query structure

   The query has an implicit field condition (status: "pending") combined with an explicit $and containing { priority: "high" }.

2. Step 2: Understand MongoDB query rules

   MongoDB allows top-level fields and operators like $and to be combined with implicit AND. $and with a single condition is valid and equivalent to just including the field directly.

3. Final Answer:

   The query will work fine and return correct results. -> Option A

4. Quick Check:

   Mixing implicit AND and $and in one object is valid [OK]

Hint: You can mix implicit AND fields and $and operator at top level [OK]

Common Mistakes:

• Thinking you cannot mix implicit fields and $and in the same object
• Believing $and requires multiple conditions
• Expecting a syntax error with $and containing one condition

5. You want to find all documents in a collection where category is "books", price is less than 20, and inStock is true. Which query uses implicit AND correctly and returns the expected results?

hard

A. db.collection.find({ category: "books", price: { $lt: 20 }, inStock: true })

B. db.collection.find({ $and: [ { category: "books" }, { price: { $lt: 20 } }, { inStock: true } ] })

C. db.collection.find({ category: "books" || price: { $lt: 20 } || inStock: true })

D. db.collection.find({ category: "books", price: { $lt: 20 } && inStock: true })

Solution

1. Step 1: Identify correct implicit AND syntax

   Using multiple fields inside one object combines conditions with implicit AND, so db.collection.find({ category: "books", price: { $lt: 20 }, inStock: true }) is correct and clean.

2. Step 2: Check other options for errors

   db.collection.find({ $and: [ { category: "books" }, { price: { $lt: 20 } }, { inStock: true } ] }) is valid but uses explicit $and unnecessarily. Options A and C use invalid JavaScript operators inside query object, causing errors.

3. Final Answer:

   db.collection.find({ category: "books", price: { $lt: 20 }, inStock: true }) -> Option A

4. Quick Check:

   Multiple fields = implicit AND, no operators needed [OK]

Hint: List all conditions as fields in one object for implicit AND [OK]

Common Mistakes:

• Using JavaScript operators like || or && inside query object
• Overusing $and when implicit AND suffices
• Mixing implicit AND and explicit $and incorrectly