HuntExams Academy logo
SQLBeginner#fundamentals

What is the difference between DBMS and RDBMS?

Answer

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 Interview 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
More SQL interview questions →