MongoDB Exam C100DBA Topic 5 Question 106 Discussion

Actual exam question for MongoDB's C100DBA exam

Question #: 106
Topic #: 5

Which of the following commands will return all the posts with number of likes greater than 100 and less than 200, both inclusive?

Adb.posts.find({ likes : { $gte : 100 , $lte : 200 } } );

Bdb.posts.find({ likes : { $gt : 100 , $lte : 200 } } );

Cdb.posts.find({ likes : { $gte : 100, $lt : 200 } } );

Ddb.posts.find({ likes : { $gt : 100, $lt : 200 > > );

Show Suggested Answer

Suggested Answer: B

by Karrie at Jan 27, 2025, 08:51 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 days ago

Ha! Option D is a classic trick question. The greater than and less than symbols should be outside the curly braces.

upvoted 0 times

...

5 days ago

I think Option C is the way to go. It's more explicit about the inclusive range with $gte and $lt.

upvoted 0 times

...

29 days ago

Option A looks like the correct one to me. It uses the $gte and $lte operators to get posts with likes between 100 and 200, inclusive.

upvoted 0 times

...

1 months ago

I'm not sure, but I think option C might also work because it uses $lt for less than 200.

upvoted 0 times

...

1 months ago

I agree with Christene, option A makes sense because it includes both 100 and 200 in the range.

upvoted 0 times

...

1 months ago

I think the correct command is A) db.posts.find({ likes : { $gte : 100 , $lte : 200 } } );

upvoted 0 times

...