HuntExams Academy
SQLBeginner#fundamentals

What is the difference between DBMS and RDBMS?

A DBMS stores data in files or hierarchies with no strict relationships. An RDBMS stores data in tables (relations) with keys, constraints and joins, and supports SQL and ACID transactions.

Example
RDBMS: MySQL, PostgreSQL, Oracle — SELECT o.id FROM orders o JOIN customers c ON c.id = o.customer_id;
Non-relational DBMS: file-based stores with no JOIN support.

Related Questions

1
SQLBeginner#ddl#dml

Difference between DELETE, TRUNCATE and DROP?

Open
2
SQLIntermediate#joins

Explain all types of JOIN with an example.

Open
3
SQLIntermediate#joins

What is a SELF JOIN?

Open