Why insert operations matter in MongoDB - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to insert a single document into the collection.

MongoDB

db.users.[1]({ name: "Alice", age: 30 })

Drag options to blanks, or click blank then click option'

AinsertOne

BfindOne

CdeleteOne

DupdateOne

Attempts:

3 left

💡 Hint

Common Mistakes

Using findOne instead of insertOne will only search, not add.

Using updateOne or deleteOne changes or removes documents, not insert.

The insertOne method adds a single document to the collection.

2fill in blank

medium

Complete the code to insert multiple documents at once.

MongoDB

db.orders.[1]([{ item: "book", qty: 3 }, { item: "pen", qty: 10 }])

Drag options to blanks, or click blank then click option'

AinsertOne

BinsertMany

Cfind

DdeleteMany

Attempts:

3 left

💡 Hint

Common Mistakes

Using insertOne with an array will cause an error.

Using find or deleteMany does not add documents.

The insertMany method adds multiple documents in one operation.

3fill in blank

hard

Fix the error in the insert operation to add a document correctly.

MongoDB

db.products.insertOne({ name: "Laptop", price: [1] })

Drag options to blanks, or click blank then click option'

Anull

B"1000"

Cprice

D1000

Attempts:

3 left

💡 Hint

Common Mistakes

Putting numbers inside quotes stores them as strings.

Using null will not set a price.

The price should be a number, not a string, to store it correctly.

4fill in blank

hard

Fill both blanks to insert a document with a nested address field.

MongoDB

db.customers.insertOne({ name: "Bob", address: { city: [1], zip: [2] } })

Drag options to blanks, or click blank then click option'

A"Seattle"

B98101

C"New York"

D12345

Attempts:

3 left

💡 Hint

Common Mistakes

Using numbers without quotes for city causes errors.

Putting zip code in quotes stores it as a string.

The city should be a string and zip a number to represent the address correctly.

5fill in blank

hard

Fill all three blanks to insert a document with a date and status.

MongoDB

db.tasks.insertOne({ title: [1], dueDate: new Date([2]), status: [3] })

Drag options to blanks, or click blank then click option'

A"Finish report"

B"2024-06-01"

C"pending"

D"completed"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around strings causes syntax errors.

Passing date without quotes to Date constructor causes errors.

The title and status are strings, and the date is passed as a string to the Date constructor.

Practice

1. Why are insert operations important in MongoDB?

easy

A. They update existing data.

B. They delete existing data.

C. They add new data to the database.

D. They create database backups.

Solution

1. Step 1: Understand the purpose of insert operations

   Insert operations are used to add new documents to a MongoDB collection.

2. Step 2: Compare with other operations

   Deleting removes data, updating changes existing data, and backups are unrelated to inserts.

3. Final Answer:

   They add new data to the database. -> Option C

4. Quick Check:

   Insert = Add data [OK]

Hint: Insert means adding new data, not deleting or updating [OK]

Common Mistakes:

• Confusing insert with update or delete operations
• Thinking insert creates backups
• Assuming insert modifies existing data

2. Which MongoDB command correctly inserts a single document into a collection named users?

easy

A. db.users.insertOne({name: 'Alice', age: 25})

B. db.users.insertMany({name: 'Alice', age: 25})

C. db.users.insert({name: 'Alice', age: 25})

D. db.users.addOne({name: 'Alice', age: 25})

Solution

1. Step 1: Identify the correct method for single document insertion

   The method insertOne is used to insert a single document.

2. Step 2: Check other options

   insertMany is for multiple documents, insert is deprecated, and addOne is invalid.

3. Final Answer:

   db.users.insertOne({name: 'Alice', age: 25}) -> Option A

4. Quick Check:

   Single insert = insertOne [OK]

Hint: Use insertOne for one document, insertMany for many [OK]

Common Mistakes:

• Using insertMany for a single document
• Using deprecated insert method
• Using non-existent addOne method

3. What will be the result of this MongoDB command?

db.products.insertMany([
  {name: 'Pen', price: 1.5},
  {name: 'Notebook', price: 3.0}
])

Assuming the collection was empty before, what will db.products.find().toArray() return?

medium

A. []

B. [{name: 'Pen', price: 1.5}, {name: 'Notebook', price: 3.0}]

C. [{name: 'Pen'}, {name: 'Notebook'}]

D. Error: insertMany requires a single document

Solution

1. Step 1: Understand insertMany behavior

   It inserts all documents in the array into the collection.

2. Step 2: Check the find() output

   Since the collection was empty, find() returns all inserted documents with their fields.

3. Final Answer:

   [{name: 'Pen', price: 1.5}, {name: 'Notebook', price: 3.0}] -> Option B

4. Quick Check:

   insertMany adds all documents [OK]

Hint: insertMany adds all array documents at once [OK]

Common Mistakes:

• Expecting empty array after insert
• Assuming fields are missing in output
• Thinking insertMany accepts only one document

4. You run this command:

db.orders.insertOne({orderId: 101, item: 'Book', quantity: 2})

But it throws an error. What is the most likely cause?

medium

A. The database connection is not established.

B. The document is missing required fields.

C. The syntax of insertOne is incorrect.

D. The collection orders does not exist.

Solution

1. Step 1: Check collection existence

   MongoDB creates collections automatically on insert, so missing collection is not an error.

2. Step 2: Verify syntax and document

   The syntax and document fields are correct and valid.

3. Step 3: Consider connection issues

   An error on insertOne often means the database connection is not established.

4. Final Answer:

   The database connection is not established. -> Option A

5. Quick Check:

   Insert error often means no DB connection [OK]

Hint: Check DB connection first if insertOne errors [OK]

Common Mistakes:

• Assuming collection must exist before insert
• Blaming syntax when it is correct
• Ignoring connection problems

5. You want to insert multiple user records but ensure no duplicates by email. Which approach best uses insert operations to avoid duplicates?

hard

A. Delete all existing users before inserting new ones.

B. Use insertOne repeatedly without any index.

C. Use insertMany without any index and ignore errors.

D. Use insertMany with ordered: false and create a unique index on email.

Solution

1. Step 1: Understand duplicate prevention

   Creating a unique index on email prevents duplicate emails in the collection.

2. Step 2: Use insertMany with ordered: false

   This allows MongoDB to continue inserting other documents even if some violate the unique index.

3. Step 3: Evaluate other options

   Repeated insertOne without index allows duplicates; ignoring errors risks data integrity; deleting all users is destructive.

4. Final Answer:

   Use insertMany with ordered: false and create a unique index on email. -> Option D

5. Quick Check:

   Unique index + insertMany ordered:false avoids duplicates [OK]

Hint: Create unique index and use insertMany ordered:false [OK]

Common Mistakes:

• Not using unique index to prevent duplicates
• Ignoring errors from duplicate inserts
• Deleting data unnecessarily