$nor operator behavior in MongoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to find documents where neither condition is true using $nor.

MongoDB

db.collection.find({ $nor: [ [1] ] })

Drag options to blanks, or click blank then click option'

A{ age: { $lt: 30 } }

B{ age: { $gt: 30 } }

C{ age: 30 }

D{ age: { $eq: 30 } }

Attempts:

3 left

💡 Hint

Common Mistakes

Using $nor with a single condition that is true instead of false.

Confusing $nor with $or.

The $nor operator takes an array of conditions and matches documents that fail all of them. Here, it matches documents where age is not less than 30.

2fill in blank

medium

Complete the code to find documents where neither age is less than 25 nor status is 'A'.

MongoDB

db.collection.find({ $nor: [ [1] ] })

Drag options to blanks, or click blank then click option'

A[ { age: { $lt: 25 } }, { status: 'A' } ]

B{ age: { $lt: 25 }, status: 'A' }

C{ age: { $lt: 25 } }, { status: 'A' }

D{ age: { $lt: 25 }, status: { $ne: 'A' } }

Attempts:

3 left

💡 Hint

Common Mistakes

Putting multiple conditions inside one object instead of separate objects in the array.

Not using an array for $nor.

The $nor operator expects an array of conditions. Each condition is an object. Here, the array has two objects: one for age less than 25, and one for status equal to 'A'.

3fill in blank

hard

Fix the error in the query to correctly use $nor with two conditions.

MongoDB

db.collection.find({ $nor: [1] })

Drag options to blanks, or click blank then click option'

A{ age: { $lt: 20 }, status: 'B' }

B[ { age: { $lt: 20 }, status: 'B' } ]

C{ age: { $lt: 20 } }, { status: 'B' }

D[ { age: { $lt: 20 } }, { status: 'B' } ]

Attempts:

3 left

💡 Hint

Common Mistakes

Passing a single object with multiple conditions instead of an array.

Passing multiple objects separated by commas without an array.

$nor requires an array of condition objects. Option D correctly provides an array with two separate condition objects.

4fill in blank

hard

Fill both blanks to find documents where neither age is greater than 40 nor status is 'C'.

MongoDB

db.collection.find({ $nor: [ [1], [2] ] })

Drag options to blanks, or click blank then click option'

A{ age: { $gt: 40 } }

B{ age: { $lt: 40 } }

C{ status: 'C' }

D{ status: 'B' }

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up greater than and less than operators.

Using wrong status values.

The $nor operator takes an array of conditions. Here, the conditions are age greater than 40 and status equal to 'C'. Documents matching neither condition are returned.

5fill in blank

hard

Fill all three blanks to find documents where none of these are true: age less than 18, status 'D', or score greater than 90.

MongoDB

db.collection.find({ $nor: [ [1], [2], [3] ] })

Drag options to blanks, or click blank then click option'

A{ age: { $lt: 18 } }

B{ status: 'D' }

C{ score: { $gt: 90 } }

D{ score: { $lt: 90 } }

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators for score.

Not separating conditions into individual objects.

The $nor operator matches documents where none of the listed conditions are true. Here, it excludes documents with age less than 18, status 'D', or score greater than 90.