Home >> MySql >> What are the differences between DBMS and RDBMS in MySql

What are the differences between DBMS and RDBMS in MySql

1-DBMS store data as file but RDBMS store data in a tabular form.

2-DBMS store data in either a hierarchical form or a navigational form but RDBMS store data in tables have an identifier called primary key and data values are stored in the form of tables.

3-In DBMS normalization does not exits but RDBMS normalization is present.

4-DBMS does not apply any security with regards to security but RDBMS defines the integrity constraint for the purpose of ACID.

5-DBMS does not support distributed database but RDBMS support distributed database.

Comments (1)
  • Pankaj Chauhan 19/Sep/2022

    Very good answer of DBMS Vs RDBMS

Post Your Comment

Next Questions
What are the differences between InnoDB and MYISAM
Table type / storage engine for table
What is the maximum size of table
What is the maximum size of MYISAM table
What is the maximum size of InnoDB table
Explain advantages of MYISAM over InnoDB
Explain advantages of InnoDB over MYISAM
What are various DDL commands
What are various DML commands
What are various DCL commands
What is the default port of server
What are the differences between MyISAM static and MyISAM dynamic
What is purpose of the NVL function
Latest version
How can find current date function
What is HEAP table
What is CSV table
What is MERGE table
What is federated table
What are data types
Numeric data types
Floating data types
Date and Time data types
String data types
Enum data types

Copyright ©2022 coderraj.com. All Rights Reserved.