BACHELOR OF BUSINESS ADMINISTRATION

BUSINESS ADMINISTRATION

BUSINESS ANALYTICS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?
A
table and row
B
table and column
C
column and row
D
database and table
Explanation: 

Detailed explanation-1: -MongoDB Databases are made up of Collections, which are similar to SQL Tables in an RDBMS database. Each Collection holds data in the form of Documents, which are similar to Rows of data in Tables. A Document has a JSON-like structure known as BSON in MongoDB, whereas a row holds data in its set of columns.

Detailed explanation-2: -How does a collection differ from a table? Instead of tables, a MongoDB database stores its data in collections. A collection holds one or more BSON documents. Documents are analogous to records or rows in a relational database table.

Detailed explanation-3: -An SQL SELECT statement typically retrieves data from tables in a database, much like a mongo shell find statement retrieves documents from a collection in a MongoDB database.

Detailed explanation-4: -MongoDB Collections are equivalent to RDBMS Tables. MongoDB Documents are equivalent to the RDBMS Rows. MongoDB Fields are equivalent to the RDBMS Columns.

There is 1 question to complete.