Questions

1 of 18

1What are indexes?

2How to create Indexes?

3On which filed you will create an index - projection field or filter field?

4What happens if I create an index on all fields of the collection?

5What is the difference between Single Field Indexes & Compound Indexes?

6How to list all indexes?

7How to drop an index?

8What is a 'Covered Query' and how do you design one using Projection?

9Explain the ESR (Equality, Sort, Range) rule. Why is the order of fields in a compound index so critical?

10What is a Sparse Index? Discuss its usage and advantages.

11What is a 'Partial Index' and when would you choose it over a 'Sparse Index'?

12How do indexes affect write performance in a collection that handles 5,000 inserts per second?

13Walk me through the output of .explain('executionStats'). What are the red flags for a senior dev?

14How do you handle 'Index Intersection'? Is it better to have two single-field indexes or one compound index?

15Explain the internal mechanics of a 'Multikey Index'. What happens if you index an array of 1,000 elements?

16How do TTL (Time-To-Live) indexes work and what are their limitations?

17When would you use a Hashed Index vs. a standard B-Tree index?

18You are scraping retail data. You need to query by category (string), sort by price (number), and filter by lastSeen (date range). How do you index this?

MongoDB

Bulk Operations

01 / 18

What are indexes?

In MongoDB, indexes are data structures that store a small portion of the collection's data, enabling efficient query execution by allowing MongoDB to quickly locate documents without scanning the entire collection.

1
Indexes support efficient execution of queries in MongoDB.
2
Without indexes, MongoDB must scan every document in a collection to return query results.
3
MongoDB uses the index to limit the number of documents it must scan.