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.

what is timestamp in mysql? : Sql dba

559

---

Differentiate between pl/sql and sql?

613

---

What is the difference between drop and truncate commands?

480

---

Can we insert in view in sql?

559

---

What is row_number () in sql?

533

---

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

640

---

Are subqueries better than joins?

525

---

What is fmtonly in sql?

526

---

Explain the difference between 'between' & 'and' operators in sql

524

---

What is sql select statement?

500

---

How run sql*plus commands that are stored in a local file?

511

---

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

544

---

What are %type and %rowtype for?

611

---

Does sql*plus also have a pl/sql engine?

552

---

What are all different types of collation sensitivity?

523

---