Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

MongoDB C100DBA Exam - Topic 5 Question 106 Discussion

Which of the following commands will return all the posts with number of likes greater than 100 and less than 200, both inclusive?
B) db.posts.find({ likes : { $gt : 100 , $lte : 200 } } );
A) db.posts.find({ likes : { $gte : 100 , $lte : 200 } } );
C) db.posts.find({ likes : { $gte : 100, $lt : 200 } } );
D) db.posts.find({ likes : { $gt : 100, $lt : 200 > > );

MongoDB C100DBA Exam - Topic 5 Question 106 Discussion

Actual exam question for MongoDB's C100DBA exam
Question #: 106
Topic #: 5
[All C100DBA Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: B

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

Limited Time Offer

25%

Off

Get Premium C100DBA Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ty
7 months ago
I thought all of them were valid options at first!
upvoted 0 times
...
Artie
8 months ago
Wait, D has a syntax error, right?
upvoted 0 times
...
Lura
8 months ago
C looks good, but it misses 200.
upvoted 0 times
...
Krystal
8 months ago
I think B is incorrect because it excludes 100.
upvoted 0 times
...
Julene
8 months ago
A is definitely the right choice!
upvoted 0 times
...
Jesusa
9 months ago
I’m confused about D; it looks like a typo with that extra ">" at the end. I hope that’s not an option!
upvoted 0 times
...
Leota
9 months ago
I practiced a similar question, and I feel like A is definitely the safest choice since it covers both ends.
upvoted 0 times
...
Katina
9 months ago
I'm not entirely sure, but I remember something about $gt and $lt not including the boundary values. So maybe C is correct?
upvoted 0 times
...
Emerson
9 months ago
I think option A is the right one because it uses both $gte and $lte, which means it includes 100 and 200.
upvoted 0 times
...
Margo
9 months ago
I'm leaning towards C. The $gte and $lt operators will give me the same result as A, but it might be a bit clearer to read.
upvoted 0 times
...
Johana
9 months ago
Option A looks good to me. The $gte and $lte operators will return the posts with likes between 100 and 200, including the endpoints. Can't go wrong with that.
upvoted 0 times
...
Celestina
9 months ago
Hmm, I'm a bit confused. I'm not sure if I should use $gte and $lte or $gt and $lt. I'll have to double-check the documentation to make sure I get this right.
upvoted 0 times
...
Salina
9 months ago
I think the answer is A. The query looks straightforward, using $gte and $lte to get the posts with likes between 100 and 200 inclusive.
upvoted 0 times
...
Garry
1 year ago
If I was a post with 100 likes, I'd be offended to be excluded from this query. Gotta love those inclusive ranges!
upvoted 0 times
...
Geoffrey
1 year ago
Option B seems to be the most straightforward approach. Why complicate it with inclusive ranges?
upvoted 0 times
Linn
1 year ago
User 3: Agreed, no need to complicate things with inclusive ranges.
upvoted 0 times
...
Janet
1 year ago
User 2: Yeah, it's simpler that way.
upvoted 0 times
...
Mike
1 year ago
User 1: I think option B is the correct one.
upvoted 0 times
...
...
Trevor
1 year 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
...
Wei
1 year 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
Marvel
1 year ago
User3: Yeah, Option C is the best choice for that query.
upvoted 0 times
...
Mammie
1 year ago
User2: I agree, $gte and $lt make it clear.
upvoted 0 times
...
Marshall
1 year ago
User1: I think Option C is the correct one.
upvoted 0 times
...
...
Ilene
1 year 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
Freida
1 year ago
Yes, option A is the right choice. It specifies the range correctly with $gte and $lte operators.
upvoted 0 times
...
Marylin
1 year ago
I think option A is correct too. It covers the range of likes we are looking for.
upvoted 0 times
...
...
Evangelina
1 year ago
I'm not sure, but I think option C might also work because it uses $lt for less than 200.
upvoted 0 times
...
Kayleigh
1 year ago
I agree with Christene, option A makes sense because it includes both 100 and 200 in the range.
upvoted 0 times
...
Christene
1 year ago
I think the correct command is A) db.posts.find({ likes : { $gte : 100 , $lte : 200 } } );
upvoted 0 times
...

Save Cancel