Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. ____________ does not provide query execution information for the rejected plans.
Correct Answer is : executionStats
2. Point out the correct statement :
Correct Answer is : When an index covers a query, MongoDB can both match the query conditions and return the results using only the index keys
3. _________ corresponds to the millis field returned by cursor.explain() in earlier versions of MongoDB.
Correct Answer is : executionTimeMillis
4. For sharded collections, explain returns the __________ for each accessed shard.
Correct Answer is : serverInfo
5. Point out the wrong statement :
Correct Answer is : If MongoDB can use an index scan to obtain the requested sort order, the result will not include a SORT stage
6. If the query planner selects a collection scan, the explain result includes a _________ stage.
Correct Answer is : COLLSCAN
7. Which of the following parameter specifies the verbosity mode for the explain output ?
Correct Answer is : verbose
8. In _____________ mode, MongoDB returns statistics describing the execution of the winning plan as well as statistics for the other candidate plans captured during plan selection.
Correct Answer is : allPlansExecution
9. If the query planner selects an _________, the explain result includes a IXSCAN stage.
Correct Answer is : Index
10. _________ which provides information on the MongoDB instance.
Correct Answer is : serverInfo
11. Which of the following returns a substring of a string ?
Correct Answer is : $substr
12. Point out the correct statement :
Correct Answer is : $toLower converts a string to lowercase
13. Which of the following accepts a single argument expression ?
Correct Answer is : $toUpper
14. Which of the following performs case-insensitive string comparison ?
Correct Answer is : $strcasecmpequals
15. Point out the wrong statement :
Correct Answer is : None of the mentioned
16. _______ is used for access text search metadata.
Correct Answer is : $meta
17. Which of the following accepts named parameters ?
Correct Answer is : None of the mentioned
18. _______ returns the number of elements in the array.
Correct Answer is : $size
19. _________ returns a value without parsing.
Correct Answer is : $literal
20. db.collection.aggregate() returns a _______ and can return result sets of any size.
Correct Answer is : cursor
