Explore topic-wise MCQs in Technical MCQs.

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.

1.

If the query planner selects a _________ the explain result includes an IXSCAN stage.

A. Document
B. Replica Set
C. Index
D. None of the above
E.
Answer» D. None of the above
2.

If MongoDB can use an index scan to obtain the requested sort order, the result will not include a SORT stage

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
Answer» C. Can be true or false
3.

_________ returns the queryPlanner and executionStats information for the evaluated method.

A. cursor.explain()
B. tablescan.explain()
C. server.explain()
D. client.explain()
Answer» B. tablescan.explain()
4.

With which storage engine, MongoDB uses memory-mapped files to store data?

A. MMAPv2
B. MMAPv1
C. WiredTiger
D. All of the above
Answer» C. WiredTiger
5.

_________ returns the queryPlanner information for the evaluated method.

A. db.explain()
B. db.collection.explain()
C. collection.explain()
D. explain()
Answer» C. collection.explain()
6.

_________provide the number of times the lock acquisitions encountered deadlocks.

A. locks.deadlock
B. lock.deadlockCount
C. lock.deadlock
D. locks.deadlockCount
Answer» E.
7.

Which of the following setting defines what constitutes a "slow" operation?

A. fastOpThresholdMs
B. slowOpThresholdZs
C. slowOpThresholdMs
D. slowOpThresholdGs
Answer» D. slowOpThresholdGs
8.

Which command returns a document that provides an overview of the database process's state?

A. serverStatus
B. currentQueue
C. currentQu
D. clientStatus
Answer» B. currentQueue