Questions
10 of 18
1How do TTL (Time-To-Live) indexes work and what are their limitations?
2How do indexes affect write performance in a collection that handles 5,000 inserts per second?
3Explain the internal mechanics of a 'Multikey Index'. What happens if you index an array of 1,000 elements?
4What is a 'Covered Query' and how do you design one using Projection?
5You 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?
6How to list all indexes?
7What is the difference between Single Field Indexes & Compound Indexes?
8What happens if I create an index on all fields of the collection?
9What are indexes?
10On which filed you will create an index - projection field or filter field?
11How to create Indexes?
12When would you use a Hashed Index vs. a standard B-Tree index?
13How to drop an index?
14How do you handle 'Index Intersection'? Is it better to have two single-field indexes or one compound index?
15What is a 'Partial Index' and when would you choose it over a 'Sparse Index'?
16Explain the ESR (Equality, Sort, Range) rule. Why is the order of fields in a compound index so critical?
17Walk me through the output of .explain('executionStats'). What are the red flags for a senior dev?
18What is a Sparse Index? Discuss its usage and advantages.
