Why querying is essential in MongoDB - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why do we use queries in databases?

Imagine you have a huge library of books. Why is it important to ask specific questions (queries) to find the books you want?

A Because queries help find only the needed information quickly without looking at everything.

B Because queries make the database slower by searching all data every time.

C Because queries delete all data after searching.

D Because queries are used to add new books to the library.

💡 Hint

Think about how you find a book in a big library without checking every shelf.

Queries let us ask for just the information we want, saving time and effort. Without queries, we would have to look through all data manually.

❓ query_result

intermediate

What does this MongoDB query return?

Given a collection students with documents containing {name, age, grade}, what will this query return?

{ age: { $gt: 18 } }

MongoDB

db.students.find({ age: { $gt: 18 } })

A All students younger than 18 years.

B All students older than 18 years.

C All students exactly 18 years old.

D All students regardless of age.

💡 Hint

The operator $gt means 'greater than'.

The query finds all documents where the age field is greater than 18, so it returns students older than 18.

📝 Syntax

advanced

Identify the syntax error in this MongoDB query

Which option shows a syntax error when trying to find documents where score is at least 70?

MongoDB

db.scores.find({ score: { $gte: 70 } })

A db.scores.find({ score: { $gte: 70 } })

B )} } 07 :etg$ { :erocs {(dnif.serocs.bd

C db.scores.find({ score: { $greaterThanOrEqual: 70 } })

D db.scores.find({ score: { $gte: '70' } })

💡 Hint

Check the operator names carefully.

The correct operator for 'greater than or equal' is $gte. Option C uses $greaterThanOrEqual, which is invalid syntax.

❓ optimization

advanced

Which query is more efficient to find users with age 30?

You want to find users aged exactly 30 in a large collection. Which query is better for performance?

A db.users.find({ age: 30 })

B db.users.find({ age: { $in: [30] } })

C db.users.find({ age: { $gte: 30, $lte: 30 } })

D db.users.find({ age: { $eq: 30 } })

💡 Hint

Simple direct matches are usually faster than complex conditions.

Using { age: 30 } is the simplest and most direct way to match age 30. Other options add unnecessary complexity that can slow down the query.

🔧 Debug

expert

Why does this MongoDB query return no results?

Given a collection products with documents like {name: 'Pen', price: 1.5}, why does this query return an empty list?

db.products.find({ price: { $gt: '1' } })

A Because the query syntax is incorrect.

B Because $gt operator only works with strings, not numbers.

C Because the collection is empty.

D Because the price field is a number but the query compares it to a string '1'.

💡 Hint

Think about data types and how MongoDB compares them.

MongoDB compares values by type. Comparing a number field to a string value causes no matches because types differ.