Question 1

Consider a collection posts which has fields: Jd, post_text, post_author, post_timestamp, post_tags etc. Which of the following query retrieves ONLY the key named post_text from the first document retrieved?

Adb.posts.finOne({},{_id:0, post_text:1})

Bdb.posts.findOne({post_text: 1})

Cdb.posts.find({},{_id:Of post_text:1})

Ddb.posts.finOne},{post_text:l})

Answer : A

Question 2

A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?

AColumn and Row

BTable and Row

CDatabase and Table

DTable and Column

Answer : B

Question 3

Which option can be used with update command so that a new document gets created if no matching document is found based on the query condition?

Aupsert command instead of update command

BThis has to be handled in application code (Node.js, PHP, JAVA, C#, etc.) and cannot be handled in mongo shell query

C{update: true, insert: true} as the third parameter of update command

DSpecify {upsert : true } as the third parameter of update command

Answer : D

Question 4

Write the command(s) are correct to enable sharding on a database "testdb" and shard a collection "testCollection" with _id as shard key.

See Below Explanation:

Answer : A

Question 5

Which of the following are common uses of the mongo shell? Check all that apply

APerform queries against MongoDB collections

BPerform administrative tasks

CUse as a JavaScript framework for your production system

Answer : A, B

Free Practice Questions for MongoDB C100DBA Exam

Question 1

Question 2

Question 3

Question 4

Question 5