What is the difference between RDBMS and DBMS?
Answer Posted / 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 |
Post New Answer View All Answers
Why are aggregate functions called so?
Are subqueries faster than joins?
how to escape special characters in sql statements? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
What schema means?
Can we create table inside stored procedure?
What do you know by pl/sql cursors?
What is the difference between join and natural join?
what is 'mysqlimport'? : Sql dba
What is coalesce sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Can we rename a column in the output of sql query?
What is the basic form of sql query?
What does select count (*) mean in sql?
How is a process of pl/sql compiled?