Answer Posted / rahul khanke

views : this are the vertiual table.. views dosent stores
the data.. if we update the table then updation is in
actual table..
M view : this are the tables based on one or more tables..
this stores the data.. updation is done then actual
updation is in M. view itself..

How do you rank data in sql?

515

---

What are reports usually used for?

564

---

what is bdb (berkeleydb)? : Sql dba

566

---

how to include character strings in sql statements? : Sql dba

551

---

what is heap table? : Sql dba

605

---

---

What are the constraints available in sql?

575

---

what is single byte over head in oracle..?

1866

---

What are user defined functions?

577

---

What is cost in sql execution plan?

487

---

What are the most important characteristics of pl/sql?

573

---

Explain the rollback statement?

572

---

What does an inner join do?

557

---

Explain foreign key in sql?

621

---

How do I view a procedure in sql?

547

---

what is the bond code in materialized view?

2489

---