Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. ________ indexes expire documents after the specified number of seconds has passed since the indexed field value.
Correct Answer is : TTL
2. Point out the correct statement :
Correct Answer is : Duration of the removal operation depends on the workload of your mongod instance
3. When the TTL thread is active, you will see _______ operations in the output of db.currentOp()
Correct Answer is : delete
4. The background task that removes expired documents runs every ________ seconds.
Correct Answer is : 60
5. Point out the wrong statement :
Correct Answer is : Index does prevent a document from having multiple elements or embedded documents in an indexed array from having the same value
6. On replica sets, the TTL background thread only deletes documents on :
Correct Answer is : primary
7. You can combine the ________ constraint with the sparse index to filter these null values from the unique index and avoid the error.
Correct Answer is : sparse
8. Which of the following method is to verify whether MongoDB used index intersection ?
Correct Answer is : explain()
9. You may not specify a unique constraint on a ______ index.
Correct Answer is : Hashed
10. Which of the following indexes are always sparse ?
Correct Answer is : all of the mentioned
11. To support ________ based sharding, MongoDB provides a hashed index type,
Correct Answer is : hash
12. Point out the correct statement :
Correct Answer is : None of the mentioned
13. ________ index type, which indexes the hash of the value of a field.
Correct Answer is : Hashed
14. The _________ property for an index causes MongoDB to reject duplicate values for the indexed field.
Correct Answer is : Multikey
15. Point out the wrong statement :
Correct Answer is : You cannot combine the sparse index option with the unique index option
16. The ______ property of an index ensures that the index only contain entries for documents that have the indexed field.
Correct Answer is : Sparse
17. MongoDB can use the _________ of indexes to fulfill queries.
Correct Answer is : intersection
18. Which of the following method is to verify whether MongoDB used index intersection ?
Correct Answer is : explain()
19. An index prefix is a subset of a ______ index, consisting of one or more keys starting from the beginning of the index.
Correct Answer is : Compound
20. Index __________ does not eliminate the need for creating compound indexes.
Correct Answer is : intersection
