In MongoDB, a "Collection" is most analogous to which concept in a relational database like MySQL?

Question

BlackTom AI · Accepted Answer

A collection in MongoDB corresponds to a table in a relational database because both group together multiple records of the same general type and provide the main unit for organizing and querying data.

Relevant concepts:
- MongoDB: database -> collection -> document -> field. Collections hold documents (JSON-like objects).
- Relational DB (MySQL): database/schema -> table -> row/record -> column. Tables hold rows (tuples) with columns.
- Operations: inserting, querying, updating, deleting operate at the collection/table level; indexing and constraints are applied to collections/tables.

Step-by-step reasoning:
1. Identify the data container: In MongoDB the container holding multiple records is called a collection. In MySQL the equivalent container is a table.
2. Map components: A MongoDB document (one JSON object) is analogous to a single row (record) in a table. A field inside a document maps to a column in a row.
3. Compare behaviors: Both collections and tables are used to execute queries (find/select), to insert new data, to update existing data, and to define indexes for performance. Schema differences exist—MongoDB collections are schema-flexible while relational tables enforce a fixed schema—but this does not change the analogous role they play.
4. Conclude mapping: Because the collection groups many documents the same way a table groups many rows, the direct analogy is collection -> table.

Why the correct choice is correct:
- "A table" is the structural and operational equivalent in relational systems.

Why other options are incorrect:
- "A stored procedure" is executable code (not a data container).
- "A foreign key" is a relational constraint to link tables, not a container.
- "A row" corresponds to a single document, not the whole collection.

Therefore the correct answer is "A table", which matches the provided answer.

In MongoDB, a "Collection" is most analogous to which concept in a relational database like MySQL?单项选择题

类似问题

The relational data model organizes data into _____.

Which category of data is typically stored in rows and columns with a fixed schema?

What is an advantage of a relational database compared to a flat-file database?

The main concept of relational databases was published in 1970 by:

A row is the same as a record in a relational database

Question at position 49 Relational databases establish the relationships between entities by means of common fields included in a file called a(n):entity.relation.association.relationship.

Question at position 32 Relational databases establish the relationships between entities by means of common fields included in a file called a(n):association.relationship.entity.relation.

Question at position 29 Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence. TrueFalse

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单