Insert with nested documents in MongoDB - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a nested document in MongoDB?

A nested document is a document stored inside another document as a value of a field. It helps organize related data together in a single record.

beginner

How do you insert a document with nested documents in MongoDB?

You include the nested document as a value of a field inside the main document when using insertOne() or insertMany().

beginner

Example: Insert a user with an address nested document.

db.users.insertOne({ name: "Alice", address: { street: "123 Main St", city: "Springfield", zip: "12345" } })

intermediate

Why use nested documents instead of separate collections?

Nested documents keep related data together, making reads faster and simpler when you want all info in one place.

intermediate

Can nested documents contain arrays or other nested documents?

Yes, nested documents can contain arrays or even other nested documents, allowing complex data structures inside one document.

Which MongoDB command inserts a document with a nested document?

A db.collection.updateOne({ name: "Bob" })

B db.collection.find({ name: "Bob" })

C db.collection.insertOne({ name: "Bob", contact: { phone: "123-4567" } })

D db.collection.deleteOne({ name: "Bob" })

insertOne() adds a new document, and the nested document is included as a field value.

What type of data can a nested document contain?

A Other documents and arrays

B Only numbers

C Only strings

D Only booleans

Nested documents can contain other documents and arrays, allowing complex structures.

Why might you use nested documents in MongoDB?

A To keep related data together in one document

B To avoid using indexes

C To make queries slower

D To split data across multiple collections

Nested documents keep related data together, making data retrieval easier.

Which of these is a valid nested document insertion?

A db.users.insertOne({ name: "Eve", hobbies: "reading" })

B db.users.insertOne({ name: "Eve", hobbies: null })

C db.users.insertOne({ name: "Eve", hobbies: { 0: "reading", 1: "swimming" } })

D db.users.insertOne({ name: "Eve", hobbies: ["reading", "swimming"] })

Arrays like ["reading", "swimming"] can be nested inside documents as field values.

What happens if you insert a document with nested documents missing some fields?

A MongoDB throws an error

B MongoDB inserts the document with missing fields omitted

C MongoDB fills missing fields with default values automatically

D MongoDB duplicates the document

MongoDB allows flexible schemas, so missing fields are simply omitted.

Explain how to insert a document with nested documents in MongoDB and why it is useful.

Think about how you store an address inside a user record.

Describe the types of data that can be stored inside nested documents in MongoDB.

Nested documents can hold complex structures, not just simple values.

Practice

1. What is the main purpose of using nested documents in MongoDB inserts?

easy

A. To create multiple collections at once

B. To group related data inside one record

C. To speed up query execution automatically

D. To enforce strict schema validation

Solution

1. Step 1: Understand nested documents concept

   Nested documents allow storing related data together inside a single MongoDB document using curly braces { }.

2. Step 2: Identify the purpose of grouping data

   This grouping helps keep related information organized and easy to access in one record.

3. Final Answer:

   To group related data inside one record -> Option B

4. Quick Check:

   Nested documents = Group related data [OK]

Hint: Nested documents group related info inside one record [OK]

Common Mistakes:

• Thinking nested documents create multiple collections
• Assuming nested documents speed up queries automatically
• Confusing nested documents with schema enforcement

2. Which of the following is the correct syntax to insert a nested document using insertOne in MongoDB?

easy

A. db.collection.insertOne({name: "Alice", address: {city: "NY", zip: 10001}})

B. db.collection.insertOne([name: "Alice", address: {city: "NY", zip: 10001}])

C. db.collection.insertOne({name: "Alice", address: [city: "NY", zip: 10001]})

D. db.collection.insertOne({name: "Alice", address: "city: NY, zip: 10001"})

Solution

1. Step 1: Check the correct use of curly braces for nested documents

   Nested documents must be inside curly braces { }, not square brackets [ ].

2. Step 2: Verify the overall insertOne syntax

   The insertOne method takes a single document object with key-value pairs, including nested documents correctly enclosed in braces.

3. Final Answer:

   db.collection.insertOne({name: "Alice", address: {city: "NY", zip: 10001}}) -> Option A

4. Quick Check:

   Curly braces for nested docs + insertOne syntax = db.collection.insertOne({name: "Alice", address: {city: "NY", zip: 10001}}) [OK]

Hint: Use curly braces { } for nested docs inside insertOne [OK]

Common Mistakes:

• Using square brackets instead of curly braces for nested docs
• Passing an array instead of an object to insertOne
• Putting nested data as a string instead of an object

3. Given the following insert command, what will be the stored document in the collection?

db.users.insertOne({name: "Bob", contact: {email: "[e-mail]", phone: "123-456"}})

medium

A. { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } }

B. { "name": "Bob", "contact.email": "[e-mail]", "contact.phone": "123-456" }

C. { "name": "Bob", "contact": [ "email", "phone" ] }

D. { "name": "Bob", "email": "[e-mail]", "phone": "123-456" }

Solution

1. Step 1: Understand how nested documents are stored

   The nested document under 'contact' is stored as a sub-document with keys 'email' and 'phone'.

2. Step 2: Compare options with expected nested structure

   Only { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } } correctly shows 'contact' as an object containing 'email' and 'phone' keys.

3. Final Answer:

   { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } } -> Option A

4. Quick Check:

   Nested document stored as object = { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "123-456" } } [OK]

Hint: Nested documents appear as objects inside main document [OK]

Common Mistakes:

• Flattening nested keys incorrectly
• Using arrays instead of objects for nested data
• Placing nested fields at top level

4. Identify the error in this MongoDB insert command:

db.products.insertOne({name: "Pen", details: [color: "blue", price: 1.5]})

medium

A. Missing comma between fields in main document

B. Missing quotes around field names

C. Using square brackets instead of curly braces for nested document

D. insertOne cannot insert nested documents

Solution

1. Step 1: Check syntax for nested documents

   Nested documents must use curly braces { }, but here square brackets [ ] are used incorrectly.

2. Step 2: Confirm other syntax elements are correct

   Field names are quoted correctly or allowed without quotes, and commas are present; insertOne supports nested docs.

3. Final Answer:

   Using square brackets instead of curly braces for nested document -> Option C

4. Quick Check:

   Nested docs need { }, not [ ] [OK]

Hint: Nested docs require curly braces { }, not square brackets [ ] [OK]

Common Mistakes:

• Confusing arrays with nested documents
• Thinking insertOne can't insert nested docs
• Forgetting commas between fields

5. You want to insert multiple user profiles with nested address documents using insertMany. Which command correctly inserts two users with nested addresses?

hard

A. db.users.insertMany([{name: "Anna", address: [city: "LA", zip: 90001]}, {name: "Mark", address: [city: "SF", zip: 94105]}])

B. db.users.insertMany({name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}})

C. db.users.insertMany([{name: "Anna", address: "city: LA, zip: 90001"}, {name: "Mark", address: "city: SF, zip: 94105"}])

D. db.users.insertMany([{name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}}])

Solution

1. Step 1: Verify insertMany syntax with array of documents

   insertMany requires an array of document objects, each with nested documents using curly braces.

2. Step 2: Check nested document syntax inside each user

   Nested 'address' fields must be objects with curly braces, not arrays or strings.

3. Final Answer:

   db.users.insertMany([{name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}}]) -> Option D

4. Quick Check:

   insertMany + array + nested docs with { } = db.users.insertMany([{name: "Anna", address: {city: "LA", zip: 90001}}, {name: "Mark", address: {city: "SF", zip: 94105}}]) [OK]

Hint: Use array of objects with nested docs in insertMany [OK]

Common Mistakes:

• Passing multiple documents as separate arguments instead of array
• Using arrays instead of objects for nested documents
• Putting nested data as strings instead of objects