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

* In DBMS relationship between two tables or files are
maintained programmatically butIn RDBMS relationship between
two tables or files can be specified at the time of table
creation.
*It does not support client/server architecture but Most of
RDBMS are support client/server architecture.
*DBMS does not support distributed databases but Most of
RDBMS are support distributed databases.
*In DBMS there are no tight security of data.butIn RDBMS
there are multiple levels security
1-Logging in at OS Level
2-Commands levels
3-Object levels
* Each table is given an extension in DBMS but Many tables
are grouped in one DB in RDBMS

*DBMS may satisfy less than 7 to 8 rules of Dr. E.F.
Codd.but RDBMS may satisfy more than 7 to 8 rules of Dr.
E.F. Codd.

Is This Answer Correct ?    62 Yes 12 No

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

Answer / pradeep kumar

1> DBMS
it Does not support client/server architecture
>it Does not support distributed Data base architecture.
> here no relationship concept.
> here no PK and FK concept.
> it is not show relationship between table.
>It supports Single User only
RDBMS
>it support client/server architecture
>it support distributed Data base architecture.
>it is based on relationship concept.
>it is show relationship between table.
> it is support PK and FK concept.
>It supports multiple users

Is This Answer Correct ?    53 Yes 6 No

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

Answer / sushil kumar

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.
6)FoxPro, IMS are Examples
http://www.hotncr.blogspot.com
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.
6)SQL-Server, Oracle are examples
http://www.hotncr.blogspot.com

Is This Answer Correct ?    53 Yes 14 No

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

Answer / praveen saini

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.
6)FoxPro, IMS are Examples

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.
6)SQL-Server, Oracle are examples

Is This Answer Correct ?    39 Yes 8 No

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

Answer / janma

DBMS:
# small organization with small amount of data.
# less memory.
# contains only flat data.
# no concept of primary key & foreign key.
# supports single user.
# can be saved in any order.

RDBMS:
# designed to take care of large amount of data.
# more memory.
# contains some relation between entities.
# includes primary key & foreign key.
# supports multiple user.
# should be sved in table format.

Is This Answer Correct ?    39 Yes 8 No

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

Answer / hema

In DBMS, has not Support Normalization Concept

But RDBMS is the Relational DBMS. So the concept of RDBMS
to be added as a 12 codd Rules. The Oracle has introduced
Codd.. So the Main Concept is Normalization Rules. After
that ACID Properties, etc.

Is This Answer Correct ?    51 Yes 25 No

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

Answer / rajesh singh

DBMS -->DATA BASE MANAGMENT SYSTEM
1-> dbms is collection of information
2->dbms does not support relational model
3->dbms does not support the security,
logshipping,replication
4->dbms use only small work area
5->

RDMS--> RELATIONAL DATA BASE MANAGNMENT SYSTEM
1->rdbms is collection of information and we can represent
a relation between two or multiple table
2->rdbms support security, replication , log shipping
3-> rdms use small and geographically area
example-- use for standby

Is This Answer Correct ?    35 Yes 9 No

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

Answer / younus

ef.codd rule

>every dbms package need to support min 6rules to declare
it self as rdbms

1>high level INSERT DELETE UPDATE
2>data distribution
3>gaurenteed access
4>view updation
5>systematic treatment for NULL
6>physical and logical data independency

Is This Answer Correct ?    31 Yes 6 No

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

Answer / amarjit walake

DBMS stands for Database Managment System
RDBMS stands for Relational Database Manegment System

Is This Answer Correct ?    45 Yes 21 No

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

Answer / velmani

dbms it may be saved in any order.. while rdbms it should be
saved in table format..

Is This Answer Correct ?    48 Yes 28 No

Post New Answer

More Database Management Interview Questions

What do you understand by clause in sql?

0 Answers  


How do I create a database?

0 Answers  


What are the basic elements of Base configuration of an oracle Database ?

1 Answers  


What are the functions of rdbms?

0 Answers  


What is indexing in database with example?

0 Answers  






What is father dbms?

0 Answers  


Why is foreign key used?

0 Answers  


What are different type of normalization?

0 Answers  


What is the main purpose of normalization?

0 Answers  


Explain what is an Exception ?

1 Answers  


What do you understand by database triggers?

0 Answers  


How view is related to data independence?

0 Answers  


Categories