DBMS Question
What is the difference between MongoDB and MySQL?

Question

DBMS Question

What is the difference between MongoDB and MySQL?

Accepted Answer

1. MongoDB is an open-source database developed by MongoDB, Inc. MongoDB stores data in JSON-like documents that can vary in structure. It is a popular NoSQL database. MySQL is a popular open-source relational database management system (RDBMS) that is developed, distributed and supported by Oracle Corporation.
2. In MongoDB, each individual records are stored as ‘documents’. In MySQL, each individual records are stored as ‘rows’ in a table.
3. Documents belonging to a particular class or group as stored in a ‘collection’ in MongoDB. Example: collection of users. A ‘table’ is used to store rows (records) of similar type in MYSQL.
4. MongoDB is what is called a NoSQL database. This means that pre-defined structure for the incoming data can be defined and adhered to but also, if required different documents in a collection can have different structures. It has a dynamic schema. MySQL as the name suggests uses Structured Query Language (SQL) for database access. The schema can not be changed. The inputs following the given schema are only entered.

Top Hexaware Technologies Java Developer interview questions & answers

Popular interview questions of Java Developer