Difference between SQL & NoSQL.

Question

Accepted Answer

SQL is a relational database management system, while NoSQL is a non-relational database management system.

SQL databases use structured query language for defining and manipulating the data.
NoSQL databases are schema-less and use various data models like key-value, document, columnar, or graph.
SQL databases are suitable for complex queries and transactions.
NoSQL databases are horizontally scalable and provide high performance for large amounts of data.
SQL databases ensure data integrity with ACID properties.
NoSQL databases prioritize scalability and availability over consistency.

Accepted Answer

SQL:

i) Categorised as RDBMS(Relational Database Model System)

ii) Stores Data in Tabular Form

iii) Can be scaled Vertically.

iv)It has static or predefined schema.(Schema->Skeleton)

v) Able to perform Complex Queries

vi) Requires DB hardware.

vii) Few Examples are MySQL,OracleDB,Microsoft SQL.

NoSQL:

i) Categorised as DDBMS(Distributed Database Model System)

ii) Stores Data in Key-value pairs,Nodes,Graphs,Etc.

iii) Can be scaled Horizontally.

iv)It has dynamic schema.(Schema->Skeleton)

v) We cannot Perform Complex Queries.

vi) Does not require special DB hardware.. Can be run as commodity Software

vii) Few Examples are MongoDB,DynamoDB.

Top Telstra Associate Software Engineer interview questions & answers