Answer Posted / 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

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1069

---

Why use stored procedures?

1098

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

984

---

what is a relationship and what are they? : Sql dba

1101

---

What are different types of tables in sql?

998

---

Which table is left in left join?

1017

---

What is a sql instance vs database?

1119

---

Does pl/sql support create command?

1113

---

What are the different types of database management systems?

1003

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4019

---

What is a recursive stored procedure?

1185

---

How do I save a sql query?

1018

---

Differentiate between pl/sql and sql?

1153

---

Does inner join return duplicate rows?

981

---

What does stand for in sql?

976

---