About RDBMS | Eklavya Online

About RDBMS

RDBMS

It exhibits all relationships. It is very easy to manage the data.
In RDBMS data is stored in tabular form.
Tables have rows & columns.
Rows represent records and column represents fields.
To access the data in RDBMS “SQL (Structured Query Language)” is used.

Limitations of RDBMS:

1. It is slow as compare to network RDBMS.
2. Redundancy of data to establish the relationship between tables.

Different types of RDBMS:

ORACLE, SQL Server, Sybase, DB2, MySQL, etc.

SQL queries are divided into three parts:

1. DDL: create, alter, rename, etc.
2. DML: insert, update, delete, truncate, etc.
3. Data retrieval: Select Queries.