MongoDB Data Modelling and Queries Interview Questions for MEAN Stack
25 MongoDB Data Modelling and Queries questions with answers for mean stack roles — 7 easy, 12 medium, 6 hard.
About MongoDB Data Modelling and Queries
MongoDB stores MEAN application data as flexible documents. This topic covers collections and documents, query operators, Mongoose with TypeScript, virtuals and methods, schema design patterns, index types, $lookup, transactions, read and write concerns, change streams, TTL and time series collections, text search and MongoDB Atlas. Expect both modelling discussions and hands-on query writing in interviews.
Sheet progressStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
✓ 3 questions free • Unlock the rest in seconds
01
Why is MongoDB a natural fit for a JavaScript stack like MEAN?
MongoDB stores data as JSON-like BSON documents, which map directly to JavaScript and TypeScript objects used in Express and Angular, so there is little translation between layers. Its flexible schema helps when requirements change quickly, and features like rich queries, aggregation, indexes, replication and Atlas cloud hosting cover most web application needs. Mongoose adds schemas, validation and TypeScript support on top of the driver.
02
What are databases, collections and documents in MongoDB?
A MongoDB deployment holds multiple databases, each database contains collections, and each collection contains documents. A document is a BSON object with fields, arrays and nested sub-documents, identified by a unique _id. Collections are roughly like tables but do not force all documents to share the same fields, although schema validation can enforce rules. A single document can be up to 16 MB in size.
03
What query and comparison operators do you use most in MongoDB?
Comparison operators include $eq, $ne, $gt, $gte, $lt, $lte, $in and $nin, for example { price: { $gte: 500, $lte: 2000 } }. Logical operators are $and, $or, $not and $nor. Element operators $exists and $type check fields, $regex matches patterns, and array operators $all, $size and $elemMatch query inside arrays. Projections choose returned fields, and sort, skip and limit shape the result.
04
What is MongoDB Atlas and what features does it offer?
MongoDB Atlas is the fully managed cloud service for MongoDB on AWS, Azure and Google Cloud. It handles provisioning, replica sets, automated backups, scaling, monitoring, security features like network access lists and encryption, and performance advice such as index suggestions. It also offers Atlas Search, Vector Search and data federation. A free tier makes it popular for learning projects and MEAN prototypes.
05
OTP codes must automatically expire ten minutes after creation. How would you implement this with MongoDB?
Store each OTP in its own collection with a createdAt date field and create a TTL index, db.otps.createIndex({ createdAt: 1 }, { expireAfterSeconds: 600 }). MongoDB's background task removes expired documents automatically, though deletion can lag by about a minute, so also check the timestamp during verification. Store a hash of the code rather than plain text, and limit verification attempts.
06
Write Mongoose queries to filter, sort, paginate and select fields for a products listing.
Situation: a client asked why we proposed MongoDB instead of the SQL database they knew. Task: explain clearly without jargon. Action: I mapped their product catalogue with varying attributes to documents, showed how it reduced joins and schema changes, admitted where SQL would be better, like complex financial reports, and proposed a reporting export. Result: the client approved MongoDB with confidence in the plan.
Define a TypeScript interface for the document, then create a Schema typed with that interface and a model with model<IUser>('User', userSchema). Mongoose infers types for queries, so findById returns a typed document. For lean queries, results are plain typed objects. Schema options like timestamps add createdAt and updatedAt, and you can type instance methods, statics and virtuals through additional generic parameters.
09
What are Mongoose virtuals, instance methods and statics?
Virtuals are computed properties not stored in MongoDB, such as fullName from firstName and lastName, or a virtual populate that links related documents. Instance methods are functions available on each document, like user.comparePassword(). Statics are functions on the model itself, like User.findByEmail(email). Virtuals are excluded from JSON output unless you enable toJSON: { virtuals: true } in schema options.
MongoDB supports single-field and compound indexes, multikey indexes for array fields, text indexes for keyword search, geospatial 2dsphere indexes for location queries, hashed indexes for sharding, wildcard indexes for unpredictable fields, TTL indexes that delete documents after a time, and unique, partial and sparse options. Atlas also provides Atlas Search for full-text relevance and Vector Search for AI similarity queries.
$lookup performs a left outer join with another collection in the same database. The basic form matches localField to foreignField and writes matching documents into an array field. The pipeline form lets you add conditions, filtering and projections on the joined collection using let variables. Often you follow it with $unwind to flatten the array. Index the foreign field so the join stays efficient.
12
You are building an e-commerce product catalogue where each category has different attributes, such as size for clothes and RAM for laptops. How would you model it in MongoDB?
Store common fields like name, price, category and stock at the top level, and keep variable specifications in an attributes array of { key, value } pairs, the attribute pattern. Create a compound index on attributes.key and attributes.value so filters work on any attribute. This avoids dozens of sparse fields and lets new categories be added without schema changes, while Mongoose validates the common fields.
13
Users can search products by name, and a regex query has become very slow. What would you do?
A regex without an anchored prefix cannot use a normal index efficiently and scans the collection. For simple word search, create a text index and use $text with a relevance score. For a better search experience with typo tolerance, autocomplete and facets, use Atlas Search or a dedicated search engine. Paginate results, limit fields with projection and debounce requests from the Angular search box.
14
A list API that uses Mongoose populate on three references has become slow. How would you improve it?
Check how many queries populate triggers and how much data each returns. Select only needed fields in populate, use lean(), and add indexes on the referenced fields. If the list always needs a customer name, store it with the extended reference pattern to avoid the join entirely. For complex filtering on related data, switch to one aggregation with $lookup and $project, and paginate.
15
Define a typed Mongoose model in TypeScript with an instance method.
Text search with scores:
db.articles.createIndex({ title: 'text', body: 'text' }, { weights: { title: 5, body: 1 } })
db.articles.find(
{ $text: { $search: 'angular signals' } },
{ score: { $meta: 'textScore' }, title: 1 }
).sort({ score: { $meta: 'textScore' } }).limit(10)
Weights make title matches rank higher. A collection can have only one text index, so include all searchable fields in it.
18
Write mongosh commands to inspect a slow query and the indexes on a collection.
Situation: in a learning portal, I first embedded all quiz attempts inside each user document. Task: attempts grew quickly and user loads became slow. Action: I moved attempts to their own collection with an index on userId and quizId, kept a small summary of best scores on the user, and wrote a migration script. Result: profile pages became much faster and reporting queries became simpler.
20
What schema design patterns are common in MongoDB?
Common patterns include embedding for one-to-few relations, referencing for one-to-many and many-to-many, the subset pattern that embeds only the most recent items, the extended reference pattern that copies frequently needed fields like a customer name into orders, the computed pattern that stores precalculated totals, the bucket pattern that groups time-series readings, and the outlier pattern for rare documents with huge arrays.
21
What are read concern and write concern in MongoDB?
Write concern controls how many replica set members must acknowledge a write before it is considered successful; w: 'majority' protects against losing data on failover, while w: 1 is faster but riskier. Read concern controls the consistency of data read, such as local for the latest on one node or majority for data acknowledged by most members. Choose stronger settings for payments and orders.
22
What are change streams in MongoDB and how can a MEAN app use them?
Change streams let an application subscribe to real-time inserts, updates and deletes on a collection, database or deployment, using the oplog of a replica set. A Node.js service can watch the orders collection and push status changes to Angular clients over Socket.IO, or sync data to search indexes and caches. Streams are resumable using a resume token after a restart.
23
Wallet balance updates sometimes produce wrong totals when two purchases happen at the same time. How do you fix this?
Reading the balance, changing it in code and saving it creates a lost-update race. Use an atomic update instead: updateOne({ _id: userId, balance: { $gte: amount } }, { $inc: { balance: -amount } }) and check modifiedCount to confirm funds were sufficient. If the operation also writes a transaction record, wrap both in a multi-document transaction. Optimistic concurrency with a version field is another option.
24
Your MongoDB collection of sensor readings is growing by millions of documents per day. How would you design for it?
Use a time series collection, which stores readings efficiently in compressed buckets with a timeField and metaField such as deviceId. Set expireAfterSeconds to drop old raw data, and keep hourly or daily aggregates in a separate collection for dashboards. Index on metaField and time, write in batches with insertMany, and plan sharding by device or a hashed key if a single replica set cannot keep up.
25
Use a MongoDB transaction in Mongoose to place an order and reduce stock together.
withTransaction retries on transient errors.
const session = await mongoose.startSession();
try {
await session.withTransaction(async () => {
const res = await Product.updateOne(
{ _id: productId, stock: { $gte: qty } },
{ $inc: { stock: -qty } },
{ session }
);
if (res.modifiedCount === 0) throw new Error('Out of stock');
await Order.create([{ userId, productId, qty }], { session });
});
} finally {
await session.endSession();
}
Transactions require a replica set, which Atlas provides by default.
Frequently asked questions
How important is MongoDB Data Modelling and Queries in MEAN Stack interviews?
MongoDB stores MEAN application data as flexible documents. This topic covers collections and documents, query operators, Mongoose with TypeScript, virtuals and methods, schema design patterns, index types, $lookup, transactions, read and write concerns, change streams, TTL and time series collections, text search and MongoDB Atlas. Expect both modelling discussions and hands-on query writing in interviews.
How should I use the MongoDB Data Modelling and Queries sheet?
Go top to bottom — easy to hard. Answer before opening each answer, tick what you solved and save misses to Last-Minute Revision.