Array update with positional $ operator in MongoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

Update a specific array element using the positional $ operator

Given the collection students with documents like:

{ "_id": 1, "name": "Alice", "grades": [85, 90, 78] }

Which update query will change the first grade equal to 90 to 95?

MongoDB

db.students.updateOne({ _id: 1, grades: 90 }, { $set: { "grades.$": 95 } })

A db.students.updateOne({ _id: 1 }, { $set: { "grades.$": 95 } })

B db.students.updateOne({ _id: 1, grades: 90 }, { $set: { "grades.$": 95 } })

C db.students.updateOne({ _id: 1, grades: { $elemMatch: { $eq: 90 } } }, { $set: { "grades.$": 95 } })

D db.students.updateOne({ _id: 1, grades: { $eq: 90 } }, { $set: { "grades.$": 95 } })

💡 Hint

The positional $ operator requires the query to match the array element directly.

Option B correctly matches the document with _id 1 and an array element grades equal to 90, then uses the positional $ operator to update that element to 95. Option B lacks the array element match, so $ cannot identify which element to update. Option B uses $elemMatch incorrectly with a direct value. Option B will not match the document because grades: {$eq: 90} requires the entire grades field to equal 90.

❓ query_result

intermediate

Result of updating multiple array elements with positional $ operator

Consider the document:

{ "_id": 2, "tasks": [ { "name": "task1", "done": false }, { "name": "task2", "done": false } ] }

What will be the value of tasks after running:

db.collection.updateOne({ _id: 2, "tasks.done": false }, { $set: { "tasks.$.done": true } })

?

A No change, update fails

B [ { "name": "task1", "done": true }, { "name": "task2", "done": true } ]

C [ { "name": "task1", "done": false }, { "name": "task2", "done": true } ]

D [ { "name": "task1", "done": true }, { "name": "task2", "done": false } ]

💡 Hint

The positional $ operator updates only the first matching array element.

The query matches the first element in tasks where done is false (task1). The update sets that element's done to true. The second element remains unchanged. So only task1.done becomes true.

📝 Syntax

advanced

Identify the syntax error in using positional $ operator

Which update query will cause a syntax error when trying to update an array element using the positional $ operator?

A db.collection.updateOne({ "items.$": 10 }, { $set: { "items.$.value": 20 } })

B )} } 02 :"eulav.$.smeti" { :tes$ { ,} 01 :"eulav.smeti" {(enOetadpu.noitcelloc.bd

C b.collection.updateOne({ "items.value": 10 }, { $set: { "items.$.value": 20 } })

D db.collection.updateOne({ "items.value": 10 }, { $set: { "items.$.value": 20 } })

💡 Hint

The positional $ operator cannot be used inside the query filter like this.

Option A uses "items.$" in the query filter, which is invalid syntax. The positional $ operator is only valid in the update document, not in the query filter. Options A, B, and D are syntactically valid.

❓ optimization

advanced

Optimizing array element update with positional $ operator

You want to update the status field to 'completed' for the first task with done: false in documents where userId is 123. Which query is the most efficient?

A db.tasks.updateOne({ userId: 123 }, { $set: { "tasks.$.status": "completed" } })

B db.tasks.updateMany({ userId: 123 }, { $set: { "tasks.$[elem].status": "completed" } }, { arrayFilters: [ { "elem.done": false } ] })

C db.tasks.updateOne({ userId: 123, "tasks.done": false }, { $set: { "tasks.$.status": "completed" } })

D db.tasks.updateMany({ userId: 123, "tasks.done": false }, { $set: { "tasks.$.status": "completed" } })

💡 Hint

Use the positional $ operator with a filter that matches the array element.

Option C updates only one document matching userId 123 and the first task with done false, setting its status to completed. Option C updates multiple documents and uses arrayFilters which is more complex and affects multiple elements. Option C lacks the array element match in the query, so $ cannot identify which element to update. Option C updates multiple documents but $ operator only updates the first matching element per document, which may be inefficient if only one update is needed.

🧠 Conceptual

expert

Understanding limitations of the positional $ operator

Which statement about the positional $ operator in MongoDB updates is TRUE?

A The positional $ operator requires the query filter to match the array element to update.

B The positional $ operator can update multiple matching elements in an array at once.

C The positional $ operator can be used in aggregation pipeline stages to update arrays.

D The positional $ operator can be used without specifying the array field in the query filter.

💡 Hint

Think about how MongoDB identifies which array element to update.

Option A is true: the positional $ operator updates the first array element matched by the query filter. Option A is false because $ updates only one element per matched document. Option A is false because $ is used in update documents, not aggregation pipelines. Option A is false because the query filter must include the array field to identify the element to update.