Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between DBMS and RDBMS??
- 76 Answers
- 202410 Views
- Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS, I also Faced
- E-Mail Answers
Answer Posted / umarali1981
DBMS:
1.Stands for DataBase Management System
2.In dbms no relationship concept
3.It supports Single User only
4.It treats Data as Files internally
5.It supports 3 rules of E.F.CODD out off 12 rules
6.It requires low Software and Hardware Requirements.
7.DBMS is used for simpler business applications
8.DBMS does not impose any constraints or security with
regard to data manipulation
9.In DBMS Normalization process will not be present
10.There is no enforcement to use foreign key concept
compulsorily in DBMS
11.FoxPro, IMS are Examples
RDBMS:
1.Stands for Relational DataBase Management System
2.It is used to establish the relationship concept between
two database objects, i.e, tables
3.It supports multiple users
4.It treats data as Tables internally
5.It supports minimum 6 rules of E.F.CODD
6.It requires High software and hardware requirements.
7.RDBMS is used for more complex applications.
8.RDBMS defines the integrity constraint for the purpose of
holding ACID PROPERTY
9.In RDBMS, normalization process will be present to check
the database table consistency
10.Although the foreign key concept is supported by both
DBMS and RDBMS but its only RDBMS that enforces the rules
11.SQL Server, Oracle are examples
Reference:
http://onlydifferencefaqs.blogspot.in/2012/07/sql-server-difference-faqs-5.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If you need to refresh a website page every time a record is updated in database, how would you do it?
What is the difference between case version and decode version?
What is the main difference between union and union all?
How is data stored in a relational database?
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
What is the difference between a catalog and a database?
Why do we need database management?
Define entity, entity type, and entity set.
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
What is write ahead logging in DBMS?
Why do we need database?
What is the instance of a relation?
Could you give me an example how, where I code checkpoint and restart. I need and example
How many types of data are there?
How does a database store data?
