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

- Free Preparation Discussions

MongoDB C100DBA Exam - Topic 8 Question 130 Discussion

Actual exam question for MongoDB's C100DBA exam

Question #: 130
Topic #: 8

[All C100DBA Questions]

What is the equivalent command in MongoDB for the following SQL query?

SELECT * FROM posts WHERE author like "%john%"

Adb.posts.find( { author: /John/ } )

Bdb.posts.find( { author: /AjohnA/ > )

Cdb.posts.find( { $like: {author: /John/} } )

Ddb.posts.find( { author: {$like: /John/} } )

Show Suggested Answer

Suggested Answer: A

by Dorcas at Jun 20, 2026, 10:26 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Edelmira

7 hours ago

I’m leaning towards A too, but I’m confused about whether the case sensitivity of the regex matters in this case.

upvoted 0 times

...

Gabriele

5 days ago

I feel like options C and D are definitely wrong because MongoDB doesn't use a $like operator.

upvoted 0 times

...

Lonny

11 days ago

I remember practicing a similar question, and I think the correct syntax for regex in MongoDB is important here.

upvoted 0 times

...

Van

16 days ago

I think the answer might be A, but I'm not entirely sure about the regex part.

upvoted 0 times

...