Insert with arrays in MongoDB - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does inserting with arrays mean in MongoDB?

It means adding multiple documents at once by passing an array of objects to the insertMany() method.

beginner

How do you insert multiple documents in MongoDB using an array?

Use the insertMany() method and pass an array of documents as the argument.

beginner

What is the difference between insertOne() and insertMany() in MongoDB?

insertOne() adds a single document, while insertMany() adds multiple documents using an array.

intermediate

Can you insert an empty array of documents in MongoDB?

No, inserting an empty array with insertMany() will not add any documents; the operation succeeds without error.

intermediate

What happens if one document in the array fails to insert in insertMany()?

By default, insertMany() stops and returns an error; you can set ordered:false to continue inserting others.

Which MongoDB method inserts multiple documents at once?

A insertAll()

B insertOne()

C insertMany()

D insertArray()

insertMany() is the correct method to insert multiple documents using an array.

What type of argument does insertMany() expect?

A An array of document objects

B A single document object

C A string

D A number

insertMany() expects an array of document objects to insert multiple documents.

If one document fails during insertMany(), what happens by default?

A All documents are inserted anyway

B The operation stops and returns an error

C Only the failed document is skipped

D The database crashes

By default, insertMany() stops and returns an error if any document fails.

Which option allows insertMany() to continue inserting after an error?

A ordered:false

B ordered:true

C continue:true

D skipErrors:true

Setting ordered:false allows insertMany() to continue inserting documents even if some fail.

Can you insert an empty array with insertMany()?

A Yes, it inserts an empty document

B Yes, it inserts a null document

C Only if you set a special flag

D No, it does nothing

Inserting an empty array does nothing; no documents are added.

Explain how to insert multiple documents in MongoDB using arrays.

Think about the method name and what it expects as input.

Describe what happens if one document in an insertMany array fails to insert.

Consider the default behavior and how to change it.

Practice

1. What does the insertMany() method do in MongoDB?

easy

A. Inserts multiple documents into a collection at once

B. Deletes multiple documents from a collection

C. Updates multiple documents in a collection

D. Finds multiple documents in a collection

Solution

1. Step 1: Understand the purpose of insertMany()

   The insertMany() method is used to add several documents to a MongoDB collection in one operation.

2. Step 2: Compare with other operations

   Deleting, updating, or finding documents are done by other methods like deleteMany(), updateMany(), and find().

3. Final Answer:

   Inserts multiple documents into a collection at once -> Option A

4. Quick Check:

   insertMany() = Inserts multiple documents [OK]

Hint: insertMany() adds many documents in one call [OK]

Common Mistakes:

• Confusing insertMany() with update or delete methods
• Thinking insertMany() inserts only one document
• Assuming insertMany() returns documents instead of inserting

2. Which of the following is the correct syntax to insert multiple documents using insertMany()?

easy

A. db.collection.insertMany('name: Alice', 'name: Bob')

B. db.collection.insertMany({name: 'Alice'}, {name: 'Bob'})

C. db.collection.insertMany([{name: 'Alice'}, {name: 'Bob'}])

D. db.collection.insertMany(name: 'Alice', name: 'Bob')

Solution

1. Step 1: Check the parameter type for insertMany()

   The method requires an array of documents, so the argument must be inside square brackets [].

2. Step 2: Validate the options

   Only db.collection.insertMany([{name: 'Alice'}, {name: 'Bob'}]) correctly passes an array of objects. The other options pass multiple arguments or wrong types, causing syntax errors.

3. Final Answer:

   db.collection.insertMany([{name: 'Alice'}, {name: 'Bob'}]) -> Option C

4. Quick Check:

   insertMany() needs an array of documents [OK]

Hint: Use square brackets [] to pass multiple documents [OK]

Common Mistakes:

• Passing documents without array brackets
• Using multiple arguments instead of one array
• Using strings instead of objects for documents

3. What will be the result of this code?

db.users.insertMany([
  {name: 'John', age: 25},
  {name: 'Jane', age: 30}
])
const count = db.users.countDocuments()

medium

A. Syntax error occurs

B. count will be 1

C. count will be 0

D. count will be 2

Solution

1. Step 1: Understand insertMany() effect

   The insertMany() call inserts two documents into the users collection.

2. Step 2: Count documents after insertion

   The countDocuments() method returns the total number of documents in the collection, which is 2 after insertion.

3. Final Answer:

   count will be 2 -> Option D

4. Quick Check:

   2 documents inserted, countDocuments() = 2 [OK]

Hint: insertMany() adds all docs; countDocuments() counts them [OK]

Common Mistakes:

• Assuming countDocuments() runs before insertMany() completes
• Thinking insertMany() inserts only one document
• Confusing countDocuments() with count() method

4. Identify the error in this MongoDB insertMany() usage:

db.products.insertMany(
  {name: 'Pen', price: 1.5},
  {name: 'Pencil', price: 0.5}
)

medium

A. insertMany() cannot insert more than one document

B. Missing array brackets around documents

C. Documents have invalid field names

D. Using insertOne() instead of insertMany()

Solution

1. Step 1: Check the argument format for insertMany()

   The method requires a single array containing all documents, but here documents are passed as separate arguments.

2. Step 2: Identify the fix

   Wrapping the documents inside square brackets [] fixes the syntax: insertMany([{...}, {...}]).

3. Final Answer:

   Missing array brackets around documents -> Option B

4. Quick Check:

   insertMany() needs an array of documents [OK]

Hint: Always wrap multiple docs in [] for insertMany() [OK]

Common Mistakes:

• Passing multiple documents as separate arguments
• Confusing insertMany() with insertOne()
• Assuming insertMany() accepts objects directly without array

5. You want to insert a list of users but only those with an age above 18. Which MongoDB operation correctly inserts only the valid users?

const users = [
  {name: 'Anna', age: 17},
  {name: 'Ben', age: 20},
  {name: 'Cara', age: 22}
];
// Which code inserts only users older than 18?

hard

A. db.users.insertMany(users.filter(u => u.age > 18))

B. db.users.insertMany(users)

C. db.users.insertMany(users.map(u => u.age > 18))

D. db.users.insertMany(users.filter(u => u.age < 18))

Solution

1. Step 1: Filter users by age before insertion

   Use JavaScript's filter() to keep only users with age greater than 18.

2. Step 2: Pass filtered array to insertMany()

   Passing the filtered array inserts only valid users. Inserting all users includes invalid ones, mapping to booleans creates invalid documents, and filtering under 18 selects the wrong users.

3. Final Answer:

   db.users.insertMany(users.filter(u => u.age > 18)) -> Option A

4. Quick Check:

   Filter first, then insertMany() [OK]

Hint: Filter array before insertMany() to insert selected docs [OK]

Common Mistakes:

• Inserting all users without filtering
• Using map instead of filter, causing wrong data
• Filtering with wrong condition (age < 18)