Collections vs tables mental model in MongoDB - Quick Revision & Key Differences

Recall & Review

beginner

What is a collection in MongoDB?

A collection in MongoDB is like a folder that holds many documents. It is similar to a table in a traditional database but stores data in flexible, JSON-like documents.

beginner

How does a table in SQL differ from a collection in MongoDB?

A table in SQL has a fixed schema with rows and columns, while a MongoDB collection stores documents that can have different structures and fields.

beginner

Why is a MongoDB collection compared to a folder in real life?

Because just like a folder holds many files, a collection holds many documents. Each document can be different, just like files can be different types.

beginner

Can documents in the same MongoDB collection have different fields?

Yes, documents in the same collection can have different fields and structures, unlike rows in a SQL table which must follow the same columns.

intermediate

What is the main advantage of collections over tables in terms of data structure?

Collections allow flexible and dynamic data structures, so you can store different types of data together without needing to define a strict schema upfront.

In MongoDB, what is the closest equivalent to a SQL table?

A Collection

B Document

C Field

D Index

A collection in MongoDB is similar to a table in SQL because it groups many documents together.

Which of the following is true about MongoDB collections?

A All documents must have the same fields

B Collections have fixed columns like tables

C Documents can have different fields

D Collections store data in rows and columns

MongoDB collections store documents that can have different fields and structures.

What is a good real-life analogy for a MongoDB collection?

A A database server

B A spreadsheet

C A single file

D A folder holding files

A collection is like a folder that holds many documents (files).

Which statement best describes a SQL table compared to a MongoDB collection?

A Tables store JSON documents, collections store rows

B Tables have fixed columns, collections allow flexible document structures

C Tables have flexible schemas, collections have fixed schemas

D Tables and collections are exactly the same

SQL tables have fixed columns, while MongoDB collections allow documents with different structures.

Why might someone choose a MongoDB collection over a SQL table?

A To store data with flexible and changing structures

B To avoid using documents

C To use rows and columns format

D To enforce strict data types

MongoDB collections are chosen for their flexibility in storing documents with different fields and structures.

Explain the mental model comparing MongoDB collections and SQL tables.

Think about how files in a folder can be different, but rows in a spreadsheet follow the same columns.

Describe the main difference in data structure flexibility between collections and tables.

Consider how MongoDB handles data compared to traditional SQL databases.