What is the difference between SQL and NoSQL databases?
a) SQL databases use structured tables, NoSQL databases use various data models
b) SQL databases are non-relational, NoSQL databases are relational
c) SQL databases store unstructured data, NoSQL databases store structured data
d) SQL databases cannot scale, NoSQL databases cannot store large amounts of data
Answer:
a) SQL databases use structured tables, NoSQL databases use various data models
Explanation:
SQL databases are relational databases that store data in structured tables with predefined schemas. They rely on SQL (Structured Query Language) for querying and managing the data. Examples include MySQL, PostgreSQL, and SQL Server.
NoSQL databases, on the other hand, are non-relational and use various data models, such as document-based, key-value pairs, wide-column stores, or graph databases. They offer greater flexibility in handling unstructured and semi-structured data.
NoSQL databases are often used for large-scale, distributed systems and applications that require high scalability and performance. Examples include MongoDB, Cassandra, and Redis.