What is the MongoDB equivalent of the following SQL query [Choose all the apply]
SELECT * FROM kgroup 
WHERE age > 30 AND age < 70

db.kgroup.find ( 

{ age: { $gte: 30, $lte: 70 } } 

)

db.kgroup.find( 

{ $and: { age: { $gte: 30 } } ,{ age: { $lte: 70 } }  } 

)

db.kgroup.find( 

{ [$and: { age: { $gte: 30 } } ,{ age: { $lte: 70 } } ] } 

)

db.kgroup.find( 

{ age: { $gt: 30, $lt: 70 } } 

)

Verified Answer
Correct Option - d

To get all Infosys Certified Mongo Developer Exam questions Join Telegram Group https://bit.ly/infy_premium_group

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Thu, 31 Jul 2025