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.
Believe that anything you can imagine you can achieve it real. Having the devotion,passion and dedication to learn & Work in Oracle field mail me @ rafidba.alvi@gmail.com."Knowledge grows when it is shared". Best Career related guidance in Oracle DBA,Oracle Apps DBA,Oracle SOA Admin/Developers,ODI Developers,OBI Developers and Oracle Designers. "A Catalyst for Oracle DBA & Apps DBA Interviews,Jobs & Career."
Wednesday, March 24, 2010
Subscribe to:
Post Comments (Atom)
superb rafi...
ReplyDeleteThanks for the compliment...Yasir & murali..
ReplyDeleteBest regards,
Rafi.
Thanks...sir
ReplyDeleteThanks...sir
ReplyDeletethanks..sir ji
ReplyDeletethnx sir clealy understand the difference
ReplyDeletenice article
ReplyDeletegreat :)
ReplyDeletesimple but very meaningful article
ReplyDeleteThnx sir
ReplyDeleteThnx sir
ReplyDeleteThis 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.
ReplyDeleteAmazing 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