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.

Why having clause is used in sql?

1019

---

Who developed sql?

1092

---

Is sqlite good enough for production?

1045

---

Can we join more than 2 tables in sql?

1093

---

what is the difference between primary key and unique key? : Sql dba

1085

---

what is the difference between a local and a global temporary table? : Sql dba

1127

---

What happens when a trigger is associated to a view?

971

---

Which is better join or inner query?

1125

---

What is data control language (dcl)?

1204

---

What is time based sql injection?

1033

---

Can we call a function containing dml statements in a select query?

1024

---

Can we commit inside a trigger?

1047

---

Can we create index on primary key?

1018

---

What are the advantages of indexing?

1025

---

What does select count (*) mean in sql?

1074

---