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.

17 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. There are many more benefits of pursuing CAPM Certification Training in USA It draws out the hidden skills and increase your market value that can be much beneficial for the future.

    ReplyDelete
  5. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete