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 / divya

The difference is dbms has no tables ,while rdbms has and
also it describes about the relationships among the tables.

The difference between dbms and rdbms is that it doesn't
show the relation while rdbms show the relation and moreover
dbms is for small organisations where rdbms for large amount
of data In DBMS all the tables are treated as different
entities.

There is no relation established among these entities. But
the tables in RDBMS are dependent and the user can establish
various integrity constraints on these tables so that the
ultimate data used by the user remains correct.

In DBMS there are entity sets in the form of tables but
relationship among them is not defined while in RDBMS in
each entity is well defined with a relationship set so as
retreive our data fast and easy.


The main advantage of an RDBMS is that it checks for
referential integrity (relationship between related records
using Foreign Keys). You can set the constraints in an RDMBS
such that when a paricular record is changed, related
records are updated/deleted automatically.

Is This Answer Correct ?    4 Yes 0 No

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

Answer / arjun

DBMS --> stands DataBase Managment System
RDBMS --> stands Relational DataBase Manegment System

Is This Answer Correct ?    4 Yes 0 No

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

Answer / vikram singh

RDBMS
01 Rdbms is a relation database management system
Dbms is a database management system
02 Rrdbms follows normalization concept
Dbms does not follows the normakization
03 Rdbms is two table joining the relation
Dbms is not join the table

Is This Answer Correct ?    4 Yes 0 No

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

Answer / swarna

*DBMS is a collection of information that is stored in
database we can retrieve & updated it easily
*It stores small amount of data
*data can be stored in any order(i.e files,records,tables)
*RDBMS is also a collection of information and we can
represent a relationsship between those tables
*it stores large amount of data
*data must be stored in table format

Is This Answer Correct ?    3 Yes 0 No

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

Answer / jitendra behera

DBMS:
In DBMS the tables are not realted.
Ex:-Foxpro,Ms-Access,Data Files.

RDBMS:
In RDBMS the tables are relates.
Ex:-ORACLE,SQL,DB2.

Is This Answer Correct ?    3 Yes 0 No

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

Answer / satish

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.

Regards:
Satish Bhutawale

Is This Answer Correct ?    3 Yes 0 No

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

Answer / anushakothapally

dbms contains only flat data where as in rdbms there will be
some relation between the entities.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / jj

DBMS don't have OOPs comcept. But RDBMs have OOPS concept.

Is This Answer Correct ?    3 Yes 1 No

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

Answer / sunil kumar chaurasia

dbms is a collection of program that enables the user to
store,modify, and extract information from database but
rdbms is suit of a software programs for creating,maintaining
and mainipulating are relational database.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / apskumar

both are used to maintain data but relationship exists
between the tuples of a data in a RDBMS where are in a DBMS
it won't

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is the use of GRANT option in IMP command ?

1 Answers  


What's the difference between clustered and non-clustered indexes?

0 Answers  


How do you create a database for an organization?

0 Answers  


What is a distributed database?

0 Answers  


What is 2-tier architecture?

0 Answers  






What is the difference between delete and truncate command in dbms?

0 Answers  


What are the features of a database management system?

0 Answers  


Explain the different types of join operations?

0 Answers  


when All datafiles related to a Tablespace are removed ?

0 Answers  


What is ordbms with example?

0 Answers  


Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

0 Answers  


Explain the advantages of rdbms?

0 Answers  


Categories