Power Up Your Study Prep: Black Friday 75% Discount! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Complete C100DBA MongoDB Materials

Page: 3 / 13
Total 172 questions

MongoDB Associate Database Administrator(Based on MongoDB 6.0 and 7.0+) Questions and Answers

Question 9

Which of the following commands finds all the documents in the posts collection with post timestamp field as null?

Options:

A.

db.posts.find( { post_timestamp: { $fieldtype: null } } )

B.

db.posts.find( { post_timestamp: { $type: null } } )

C.

db.posts.find( { post_timestamp : { $type; 10 > > )

D.

db.posts.find( { post_timestamp: { $fieldtype: 10 } } )

Question 10

Which of the following is a valid insert statement in mongodb? Select all valid.

Options:

A.

db.test.push({x:2,y: " apple " })

B.

db.test.insert« " x " :2, " y " : " apple " })

C.

db.test.insert({x:2,y: " apple " })

D.

db.test.insert({x:2},{y: " apple " })

Question 11

If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?

Options:

A.

None of the above

B.

The query used an index to fetch the results

C.

The query returned 0 documents

D.

The query returned 30000 documents after scanning the documents

Question 12

Which of the documents below will be retrieved by the following query? Assume the documents are stored in a collection called " sample " . Check all that apply.

db.sample.find( { " $or " : [ { " a " : { " $in " : [ 3, 10] > }, { " b " : { " $lt " : 2 > > ] > )

Options:

A.

{ ' ' __id " :3, " a " : 4, " c " :0, " b " :14}

B.

{ ' ' _Jd " :7, " a " : 8, " c " :1, " b " :7}

C.

{ " .Jd " :6, " a " : 1, " c " :1, " b " :5}

D.

{ ' ' \Jd " :9, " a " : 17, " c " : 1, " b " : 1}

E.

{ \Jd " :10, " a " : 3, " c " : 1, " b " : 1}

F.

{ " .Jd " :: 2, " a " : 2, " c " :: 0, " b " : 1}

G.

{ " .Jd " :: 4, " a " : 5, " c " :: 0, " b " : 17}

Page: 3 / 13
Total 172 questions