(A). Wide-column
(B). Document
(C). Both A and B
(D). None of these
MCQAnswer: Key-value
Examples of SQL database and NoSQL database
| NoSQL database |
Relational database |
| MongoDB |
Oracle |
| Apache CouchDB |
IBM DB2 |
| Apache HBase |
IBM DB2 |
| Oracle NoSQL Database |
Microsoft SQL Server |
| Apache Cassandra DB |
Maria DB |
| Riak |
PostgreSQL |
| Objectivity InfiniteGraph |
|
Difference between NoSQL database and SQL database
| NoSQL |
SQL |
| NoSQL stands for Non-relational or distributed database system. |
SQL stands for RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS) |
| NoSQL databases have dynamic schema |
SQL databases have a static or fixed or predefined schema |
| NoSQL databases are ideal for hierarchical data storage. |
SQL databases are not ideal for hierarchical data storage. |
| NoSQL databases are not so decent for complex queries |
SQL databases are ideal for complex queries |
| NoSQL databases are Horizontally scalable. |
SQL databases are Vertically Scalable. |
| NoSQL database Follows consistency, availability, and partition tolerance. |
SQL database follows atomicity, consistency, isolation, and durability. |
| Examples of NoSQL databases: MongoDB, GraphQL, HBase, Neo4j, Cassandra, etc |
Examples of SQL databases: MySQL, PostgreSQL, Oracle, MS-SQL Server, etc |
