Answer Posted / jyoti ranjan parida

DBMS-Database management system.
=>In dbms no relationship concept
=>It can't impliment constraints in table and no security
of data.
=>It supports Single User only
=>It treats Data as Files internally
=>It supports 3 rules of E.F.CODD out off 12 rules
=>It requires low Software and Hardware Requirements.
=>Examples:Foxpro
RDBMS-Relational management system
=>It is used to establish the relationship concept between
two database objects, i.e, tables
=>It impliment constraints in table and no security of data.
=>It supports multiple users
=>It treats data as Tables internally
=>It supports minimum 6 rules of E.F.CODD
=>It requires High software and hardware requirements.
=>examples:Oracle,mysql,DB2.

Is sql dba a good career? : SQL DBA

992

---

What is rename in sql?

974

---

what is the difference between nested subquery and correlated subquery?

1055

---

Explain how exception handling is done in advance pl/sql?

999

---

Does mysql support pl sql?

1175

---

How many types of relationship are there?

1031

---

Explain select statements in sql?

1058

---

How do I save a sql query?

1015

---

how to create a new view in mysql? : Sql dba

938

---

What is union and union all keyword in sql and what are their differences?

1108

---

What is function and procedure?

1033

---

What is the difference between the sql*loader and import utilities? : aql loader

1043

---

what is 'mysqlshow'? : Sql dba

1027

---

What is character functions?

1061

---

what is text? : Sql dba

1072

---