what is the difference between DBMS and RDBMS??

Answers were Sorted based on User's Feedback



what is the difference between DBMS and RDBMS??..

Answer / dharshana

DBMS:
-Is a single user system.
-Does not support client server architecture.
-Normalization techniques cannot be applied.
-Memory allocation is less.

RDBMS:
-Is a multi user system.
-Supports client server architecture.
-Normalization techniques cannot be applied for checking
the consistency of the database system.
-Memory allocation is huge.

Is This Answer Correct ?    29 Yes 9 No

what is the difference between DBMS and RDBMS??..

Answer / vikas jaiswal

A DBMS has to be persistent that is it should be accessible
when the program created the data ceases to exist or even
the application that created the data restarted. A DBMS
also has to provide some uniform methods independent of a
specific application for accessing the information that is
stored.

RDBMS is a Relational Data Base Management System
Relational DBMS. This adds the additional condition that
the system supports a tabular structure for the data with
enforced relationships between the tables. This excludes
the databases that don't support a tabular structure or
don't enforce relationships between tables.

Yes you can say 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 whereas the rdbms is more with this regard bcz
rdbms difine the integrity constraint for the purpose of
holding ACID PROPERTY.

Regards
Vikas Jaiswal

Is This Answer Correct ?    28 Yes 17 No

what is the difference between DBMS and RDBMS??..

Answer / mohnish chopra

In DBMS, data can be stored in any form i.e in form of
files,records,tables etc.
Whereas in RDBMS, DATA CAN BE STORED ONLY IN FORM OF TABLES
WHERE COLUMNS REPRESENTS ATTRIBUTES AND ROWS REPRESENTS
RECORDS..

Is This Answer Correct ?    11 Yes 0 No

what is the difference between DBMS and RDBMS??..

Answer / uday singh

The main difference between DBMS and RDBMS is DBMS does not
impose any constraints or security with regard to data
manipulation it is user or the programmer responsibility to
ensure the ACID(Atomicity Consistency Isolation and
Durability) PROPERTY of the database whereas the rdbms is
more with this regard bcoz rdbms define the integrity
constraint for the purpose of holding ACID PROPERTY.

Is This Answer Correct ?    10 Yes 0 No

what is the difference between DBMS and RDBMS??..

Answer / zubair ali

DBMS:1)In dbms no relationship concept
2)It supports Single User only
3)It treats Data as Files internally
4)It supports 3 rules of E.F.CODD out off 12 rules
5)It requires low Software and Hardware Requirements.

RDBMS:
1)It is used to establish the relationship concept between
two database objects, i.e, tables
2)It supports multiple users
3)It treats data as Tables internally
4)It supports minimum 6 rules of E.F.CODD
5)It requires High software and hardware requirements.

Is This Answer Correct ?    25 Yes 16 No

what is the difference between DBMS and RDBMS??..

Answer / akhilesh bisht

1.In DBMS the relation between two tables or files are
maintained by programming.Where as no need of programming
in RDBMS it relates dynamically.
2.Neither client-server support nor distributed database
support available in DBMS whereas both are available in
RDBMS.
3.Follows >7 Codds rule in DBMS, whereas RDBMS follows >7 codds
rules.
4.Data is not secure in DBMS as compare to RDBMS.

Is This Answer Correct ?    45 Yes 37 No

what is the difference between DBMS and RDBMS??..

Answer / chandrasekhar.patri

dbms is not providing securirty for data, where as rdbms
will provide it... and also normalization will not support
in dbms,where as rdbms will supports it..dbms will stores
flat data where as in rbbs realtions between data and tables
and entitys will provide................

Is This Answer Correct ?    7 Yes 0 No

what is the difference between DBMS and RDBMS??..

Answer / jyothish

DBMS Doesnot follow the normalization concepts while RDBMS
follows the normalization concepts. This is the major
difference between them

Is This Answer Correct ?    6 Yes 0 No

what is the difference between DBMS and RDBMS??..

Answer / divya

DBMS-Data Base Management Sysytem----No relation between
datas stored in databaseRDBMS-Relational Data Base
Management System-Relation between datas stored in
databaseDBMS stands for Database Management System which is
a general term for a set of software dedicated to
controlling the storage of data.

RDMBS stand for Relational DataBase Management System. This
is the most common form of DBMS. Invented by E.F. Codd, the
only way to view the data is as a set of tables. Because
there can be relationships between the tables, people often
assume that is what the word "relational" means. Not so.
Codd was a mathematician and the word "relational" is a
mathematical term from the science of set theory. It means,
roughly, "based on tables".

Is This Answer Correct ?    5 Yes 0 No

what is the difference between DBMS and RDBMS??..

Answer / keerthi krishna

DBMS id data base management system where the data is
stored a particular order while RDBMS is relational data
base management system where the data is stored based on
the relationships

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is the purpose of normalization in dbms?

0 Answers  


Can you explain insert, update and delete query?

0 Answers  


What does partition mean in database?

0 Answers  


Describe the difference between data and database administration.

0 Answers  


What is like operator for and what are wild cards?

0 Answers  






When a form is invoked with CALL_FORM does Oracle forms issues?

1 Answers  


What is limit in dbms?

0 Answers  


What are the steps to follow when preparing to create a table?

0 Answers  


What is cold backup and hot backup (in case of oracle)?

0 Answers  


Define entity.

0 Answers  


define aggregate functions.

0 Answers  


What is data model in database?

0 Answers  


Categories