Which query bypasses the first 5 customers and returns the next 10?

June 25, 2021 Team Pa 0 Comment

MongoDB LinkedIn Assessment Questions and Answers

db.customers.find({}, {skip: 5, limit: 10})
db.customers.find({}.page(5).take(10))
db.customers.find({}).skip(5).take(10)
db.customers.find({}).skip(5).limit(10)

Leave a Reply Cancel reply

In the MongoDB shell, how can you tell if an index was used with a query?In the MongoDB shell, how can you tell if an index was used with a query?

db.customers.find({lastName: ‘smith’}).explain() db.customers.find({lastName: ‘smith’}).perf() db.customers.find({lastName: ‘smith’}).plan() db.customers.find({lastName: ‘smith’}).usedIndex()[...]

READ MORE

You’d like a set of documents to be returned in last name, ascending order. Which query will accomplish this?You’d like a set of documents to be returned in last name, ascending order. Which query will accomplish this?

db.persons.find().sort({lastName: -1}} db.persons.find().sort({lastName: 1}} db.persons.find().sort({lastName: ascending}} db.persons.find().sort({lastName: $asc}}[...]

READ MORE

You are going to do a series of updates to multiple records. You find setting the multi option of the update() command too tiresome. What should you do instead?You are going to do a series of updates to multiple records. You find setting the multi option of the update() command too tiresome. What should you do instead?

Use the replaceMany() command instead Use the updateMulti() command instead Use the updateMany() command instead Set the global multi option[...]

READ MORE