What is the difference between RDBMS and DBMS?

Answers were Sorted based on User's Feedback



What is the difference between RDBMS and DBMS?..

Answer / mahesh mishra

1)DBMS permits only one person to access the database at a
given time.But RDBMS gives the multiple access the database
at a given time.
2)DBMS organised the data in any formmate but RDBMS allows
only in row and column format.
3)In DBMS we can not create the the relationshs but in
RDBMS we can not create the relationship between the tables

Is This Answer Correct ?    347 Yes 109 No

What is the difference between RDBMS and DBMS?..

Answer / abdul waheed

its very simple,,,,there are three main differences b/w
RDBMS & DBMS

1- There is a condition in RDBMS that data should be stored
in tabular(only in Rows and column) Form/ In DBMS data can
be stored in any format

2- In RDBMS all the tables and the content of the tables
keeps relationship...thats y it called Relation DBMS///// in
DBMS column or table dont have any relationship

3- RDBMS can be accessed by multiple users at a same
time////////// DBMS can be accessed only by single user.


Oracle,SQl,DB2,and My Sql all these databases use RDBMS

Is This Answer Correct ?    97 Yes 11 No

What is the difference between RDBMS and DBMS?..

Answer / vishal sharma

#1 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.


#2 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.

#3 DBMS are for smaller organizations with small amount of
data, where security of the data is not of major concern
and RDBMS are designed to take care of large amounts of
data and also the security of this data.

Is This Answer Correct ?    81 Yes 23 No

What is the difference between RDBMS and DBMS?..

Answer / sree

DBMS or RDBMS are the different datebases models evolved
one after one.

Any file in this universe majorly falls into the following
categories
i) Data in a text file or other files
(.txt, .doc, .pdf, .ini etc.,)
ii) Data in a table format (.xls, .csv., etc)

In the first category the data is in a file and hence we
say it is not organised and no point of relation with other
files.

In the second category the data is in a table format which
contains colums and rows and hence we say it is in a well
organised manner. This kind of well organised data
representation is the base for all the Databases we use
these days.

Both DBMS and RDBMS are used to represent data in table
format, but it deffers how we represent and how we inter
connect, whats the data capacity, ease, application,
effeciency based on necessity etc.,

For example,
1) One Small Finance Company in a village has 500 customer
and 1000 transactions in an year. At the end of the year
the business owner want to see all the transactions to
analyse his business development. Here based on the
necessity and requirement the owner can use a excel or any
other spreadsheet model which is nothing but DBMS, just
managing database

2) A big insuracne company (Like LIC, Metlife) with huge
data like 1 crore customers (Includes customer address,
phone no., Email, ID, Policy Information etc.,), 2 Crore
claims, etc., Here the Company owner cannont use an excel
and hence the era of DBMS later lead to the invention of
RDBMS (Like Oracle, Teradata, DB2 etc.,) where the data
would not in a single table/excel sheet but in a different
tables with inter relationship.

What kind of relationship exists between tables?

As per example 2, let me take assume the business owner had
many tables among which the following are two tables
i) Customer_Details (This table is with details of customer)
ii) Customer_Claims (This table is with details of the
claims)

Customer_Details is a driving table for Customer_Claims as
the ID is the key which would be common between both the
tables. without id we cannot identify a claim of a
particular customer, this is called as relationship between
oth the tables.

Is This Answer Correct ?    50 Yes 6 No

What is the difference between RDBMS and DBMS?..

Answer / rusabh tiwari

RDBMS IS RELATIONAL DATABASE MANAGEMENT SYSTEM IT MAINTAIN
A RELATION BETWEEN ENTITY .AND DBMS IS DATABASE MANAGEMENT
SYSTEM IT IS MAINTAIN A RELATION BETWEEN DATABASE

Is This Answer Correct ?    72 Yes 38 No

What is the difference between RDBMS and DBMS?..

Answer / ajay

DBMS IS A GENERAL SOFTWARE SYSTEM FOR MANAGEMENT OF DATA.
WHERE AS RDBMD IS A SPECIFIC TYPE OF DBMS WHICH IS BASED ON
PRINCIPAL OF SET THEORY . RELATION WORD IN SET THEORY IS
DEFINED AS SUBSET OF THE CAETESIAN PRODUCT OF TWO OR MORE
SETS. DATA INTO A TABLE IS REPRESENTED IN FORM OF RELATION.
Apart from this E. F. Codd has prescribed 12 guideline for
DBMS to be a RDBMS WHICH IS KNOWK AS CODD'S RULE.

Is This Answer Correct ?    48 Yes 18 No

What is the difference between RDBMS and DBMS?..

Answer / akhilesh

The difference in RDBMS and DBMS does not lie in the way
tables and data are related to each other (ie. the Foreign
Key relationship). dBase and MS Access are DBMS's which
have foreign key relationships implemented.

RDBMS is based on the concepts of Relational Set Theory in
mathematics and hence the name Relational Database
Management System. They implement the project, restrict,
union, intersect, difference, product, divide and join in
the queries. DBMS's on the other hand, supports two or
more, but not all of the concepts.

Is This Answer Correct ?    105 Yes 76 No

What is the difference between RDBMS and DBMS?..

Answer / kalpana

Example of RDBMS is - ORACLE ,MY SQL..
Example of DBMS is - MSEXCEL

Is This Answer Correct ?    47 Yes 22 No

What is the difference between RDBMS and DBMS?..

Answer / divya singh rajput

DBMS is collection of interrelated data and program to
access that data but RDBMS is collection of dbms for strong
security of data.

Is This Answer Correct ?    9 Yes 2 No

What is the difference between RDBMS and DBMS?..

Answer / upasana

dbms is data base mgmt system....bt rdbms is relational
data base mgmt system

Is This Answer Correct ?    7 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,


Differentiate between syntax and runtime errors.

0 Answers  


how to shutdown mysql server? : Sql dba

0 Answers  


what tools available for managing mysql server? : Sql dba

0 Answers  


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  






What is sql dialect?

0 Answers  


What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,


I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,


How to fetch alternate records from a table?

0 Answers  


what happens if you no create privilege in a database? : Sql dba

0 Answers  


Explain scalar functions in sql?

0 Answers  


How to return multiple rows from the stored procedure?

0 Answers  


Categories