| Snaprecruit.com

| Snaprecruit.com

Interview question based on skill :

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. _________ operations that use an index often have better performance than those that do not use an index.

Correct Answer is : Sort

2. Point out the wrong statement :

Correct Answer is : The query scans the index and the collection

3. A prefix of a _______ index is a subset that consists of one or more keys at the start of the index key pattern.

Correct Answer is : primary

4. Sort operations that do not use an index will abort when they use _______ megabytes of memory.

Correct Answer is : 32

5. Point out the correct statement :

Correct Answer is : If you sometimes query on only one key and at other times query on that key combined with a second key, then creating a compound index is more efficient than creating a single-key index

6. An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition.

Correct Answer is : equality

7. __________ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation.

Correct Answer is : db.collection.totalIndexSize()

8. To avoid creating an index with a name that exceeds the index name length limit, you can pass the _____ option to the db.collection.createIndex() method.

Correct Answer is : name

9. Indexes do not have to fit entirely into ______ in all cases.

Correct Answer is : ROM

10. ________ is the ability of a query to narrow results using the index.

Correct Answer is : Cardinality

11. What is the interactive shell for MongoDB called ?

Correct Answer is : mongo

12. Point out the correct statement :

Correct Answer is : NoSQL Manager for MongoDB is a MS Windows GUI application for MongoDB management with Shell

13. Administrative information in MongoDB can also be accessed through :

Correct Answer is : web interface

14. Which of the following is web-based client software for MongoDB ?

Correct Answer is : Database Master

15. Point out the wrong statement :

Correct Answer is : Cassandra is most popular for its document stores management system

16. ___________ provides statistics on the per-collection level.

Correct Answer is : mongotop

17. ___________ is a command-line tool that displays a summary list of status statistics for a currently running MongoDB instance.

Correct Answer is : mongostat

18. mongostat tool is similar to the UNIX/Linux _________ utility.

Correct Answer is : vmstat

19. Which of the following tool is similar to the UNIX/Linux top utility ?

Correct Answer is : mongotop

20. mongosniff requires the ___________ network library and is only available for Unix-like systems.

Correct Answer is : Libpcap