Wednesday, March 24, 2010

Difference between DBMS and RDBMS(IMPORTANT INTERVIEW QUESTION)

Hi,
This is sure an important interview question asked to me in many interviews

what is the difference between DBMS and RDBMS??

1)Data Base Management System is a process of managing
data for efficient retrivel & storage of data.
Ex: sysbase , Foxpro
The database which is used by relations(tables) to
acquire information retrival are known as RDBMS
EX: SQL, ORACLE,MY-SQLSERVER

2)In DBMS,client server concept is not present.
In RDBMS,client server architecture is present (i.e) the
client sends the request to the server and the server
responds to that particular request.

3)DBMS does not impose any constraints or security with
regard to data manipulation. It is user or the programmer
responsibility to ensure the ACID PROPERTY of the database.
RDBMS defines the integrity constraint for the purpose of
holding ACID PROPERTY.

4)In DBMS Normalization process will not be present.
In RDBMS, normalization process will be present to check
the database table cosistency.

5)In DBMS we treats Data as Files internally.
In RDBMS we treats data as Tables internally.

6)DBMS supports 3 rules of E.F.CODD out off 12 rules.
RDBMS supports minimum 6 rules of E.F.CODD.

7)DBMS does not support distributed databases.
RDBMS support distributed databases.

8)In DBMS we see small organization with small amount of data.
RDBMS designed to take care of large amount of data.

9)DBMS contains only flat data.
RDBMS contains some relation between entities.

10)DBMS supports single user
RDBMS supports multiple user

Best regards,

Rafi.

5 comments: