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.

14 comments:

  1. Thanks for the compliment...Yasir & murali..


    Best regards,

    Rafi.

    ReplyDelete
  2. thnx sir clealy understand the difference

    ReplyDelete
  3. simple but very meaningful article

    ReplyDelete
  4. This was really a great and descriptive note on the topic. I also got to read another good article on the same topic: Difference Between DBMS and RDBMS I would definitely recommend your readers to through this.

    ReplyDelete
  5. Amazing article. I have got to know so much good information about the same. Thanks! I would also recommend your readers to read this article: Difference Between DBMS and RDBMS. It's also very informative, especially the Rule No.6

    ReplyDelete