Database and collection creation in MongoDB - Step-by-Step Execution

Concept Flow - Database and collection creation

Start Mongo Shell

↓

Create or Switch Database

↓

Create Collection

↓

Insert Document (optional)

↓

Verify Collection Exists

↓

End

This flow shows how to start MongoDB shell, create or switch to a database, create a collection, optionally insert a document, and verify the collection.

Execution Sample

MongoDB

use myDatabase
 db.createCollection('myCollection')
 db.myCollection.insertOne({name: 'Alice'})
 db.getCollectionNames()

This code switches to 'myDatabase', creates 'myCollection', inserts a document, and lists collections.

Execution Table

Step	Command	Action	Result
1	use myDatabase	Switch to or create database 'myDatabase'	Switched to db myDatabase
2	db.createCollection('myCollection')	Create collection named 'myCollection'	Collection created
3	db.myCollection.insertOne({name: 'Alice'})	Insert one document into 'myCollection'	Inserted 1 document
4	db.getCollectionNames()	List all collections in current database	["myCollection"]

💡 All commands executed successfully; collection 'myCollection' exists in 'myDatabase'.

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4
Current Database	none	myDatabase	myDatabase	myDatabase	myDatabase
Collections in Database	none	none	["myCollection"]	["myCollection"]	["myCollection"]
Documents in myCollection	none	none	none	[{"name": "Alice"}]	[{"name": "Alice"}]

Key Moments - 3 Insights

Why does 'use myDatabase' create the database even if it doesn't exist?

In MongoDB, switching to a database with 'use' creates it only when you first store data. Step 1 switches context; actual creation happens after inserting data in Step 3.

What happens if you insert a document without creating the collection first?

MongoDB automatically creates the collection when you insert the first document, so explicit creation in Step 2 is optional.

How do you verify the collection was created?

Step 4 uses 'db.getCollectionNames()' to list collections, confirming 'myCollection' exists.

Visual Quiz - 3 Questions

Look at the execution table, what is the current database after Step 1?

A admin

B myDatabase

C test

D none

💡 Hint

Check the 'Current Database' row in variable_tracker after Step 1.

At which step is the first document inserted into the collection?

A Step 3

B Step 2

C Step 1

D Step 4

💡 Hint

Look at the 'Action' column in the execution_table for document insertion.

If you skip Step 2 and insert a document directly, what will happen?

A Error because collection does not exist

B Database is deleted

C Collection is created automatically

D Nothing happens

💡 Hint

Refer to the key moment about inserting without creating collection.

Concept Snapshot

MongoDB Database and Collection Creation:
- Use 'use dbName' to switch or create a database.
- Use 'db.createCollection(name)' to create a collection explicitly.
- Inserting a document auto-creates the collection if missing.
- Use 'db.getCollectionNames()' to list collections.
- Database is created when data is first stored.

Full Transcript

This visual execution shows how to create a database and collection in MongoDB. First, the 'use' command switches to or creates a database context. Then, 'db.createCollection' explicitly creates a collection. Inserting a document adds data to the collection and creates the database if it did not exist. Finally, listing collections confirms the collection's existence. Variables track the current database, collections, and documents step-by-step. Key moments clarify common confusions about database creation timing and automatic collection creation. The quiz tests understanding of these steps.

Practice

1. What does the command use myDatabase do in MongoDB?

easy

A. It deletes the database named 'myDatabase'.

B. It creates a collection named 'myDatabase'.

C. It switches to the database named 'myDatabase' or creates it if it doesn't exist.

D. It lists all collections in the current database.

Solution

1. Step 1: Understand the use command

   The use command in MongoDB switches the current database context to the specified database.

2. Step 2: Behavior when database does not exist

   If the specified database does not exist, MongoDB creates it when you first store data in it.

3. Final Answer:

   It switches to the database named 'myDatabase' or creates it if it doesn't exist. -> Option C

4. Quick Check:

   use databaseName switches or creates database [OK]

Hint: Remember: use switches or creates database [OK]

Common Mistakes:

• Thinking use creates collections
• Confusing database and collection commands
• Assuming use deletes databases

2. Which of the following is the correct syntax to create a new collection named users in the current database?

easy

A. db.createCollection('users')

B. create collection users

C. db.users.create()

D. use users

Solution

1. Step 1: Identify the MongoDB command for collection creation

   The correct MongoDB command to create a collection is db.createCollection('collectionName').

2. Step 2: Match the syntax with the options

   db.createCollection('users') matches the correct syntax exactly for creating a collection named 'users'.

3. Final Answer:

   db.createCollection('users') -> Option A

4. Quick Check:

   Use db.createCollection('name') to create collections [OK]

Hint: Use db.createCollection('name') to create collections [OK]

Common Mistakes:

• Using SQL-like syntax such as 'create collection users'
• Trying to create collection with db.users.create()
• Using use users to create collection

3. What will be the result of running these commands in order?

use shopDB
db.createCollection('products')
db.getCollectionNames()

medium

A. Error: createCollection not found

B. ['shopDB']

C. []

D. ['products']

Solution

1. Step 1: Switch to or create the database 'shopDB'

   The use shopDB command switches to the database named 'shopDB'. If it doesn't exist, it will be created when data is added.

2. Step 2: Create a collection named 'products'

   The command db.createCollection('products') creates a new collection called 'products' inside 'shopDB'.

3. Step 3: List collections in the current database

   db.getCollectionNames() returns an array of collection names in the current database. Since 'products' was created, it returns ['products'].

4. Final Answer:

   ['products'] -> Option D

5. Quick Check:

   Created collection appears in db.getCollectionNames() [OK]

Hint: Created collections appear in db.getCollectionNames() [OK]

Common Mistakes:

• Expecting database name in collection list
• Assuming collections list is empty after creation
• Confusing collection names with database names

4. Identify the error in this MongoDB command sequence:

use testDB
db.createCollection(users)

medium

A. Missing quotes around collection name 'users'.

B. The use command is incorrect.

C. The collection name cannot be 'users'.

D. The command createCollection does not exist.

Solution

1. Step 1: Check syntax of createCollection command

   The collection name must be a string, so it requires quotes around it.

2. Step 2: Identify the error in the command

   The command db.createCollection(users) is missing quotes around 'users', causing a syntax error.

3. Final Answer:

   Missing quotes around collection name 'users'. -> Option A

4. Quick Check:

   Collection names must be strings in quotes [OK]

Hint: Always put collection names in quotes in createCollection [OK]

Common Mistakes:

• Omitting quotes around collection names
• Misusing use command syntax
• Thinking collection names cannot be common words

5. You want to create a new database called libraryDB and inside it a collection named books. Which sequence of commands will achieve this correctly?

hard

A. create database libraryDB
create collection books

B. use libraryDB
db.createCollection('books')

C. use books
db.createCollection('libraryDB')

D. db.createCollection('libraryDB.books')

Solution

1. Step 1: Switch to or create the database 'libraryDB'

   The command use libraryDB switches to the database named 'libraryDB'. If it doesn't exist, it will be created when data is added.

2. Step 2: Create the collection 'books' inside 'libraryDB'

   Using db.createCollection('books') creates the collection named 'books' in the current database context.

3. Final Answer:

   use libraryDB db.createCollection('books') -> Option B

4. Quick Check:

   Switch database then create collection [OK]

Hint: Switch database first, then create collection inside it [OK]

Common Mistakes:

• Trying to create database and collection in one command
• Using SQL syntax like 'create database'
• Confusing collection and database names