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