Answer Posted / udaykumar

view is a virtual memory.it doesn't contain the data but it
has a structure.
simple
complex
materialized
snapshot
force
inline
parametric

Why is stored procedure faster than query?

478

---

When to use inner join and left join?

511

---

Can we use the cursor's to create the collection in PL/SQL?

507

---

Is postgresql a server?

564

---

How to add, remove, modify users using sql?

549

---

---

What is bulk compiling in pl/sql.?

600

---

Which type of cursor is used to execute the dml statement?

519

---

How do I turn a list into a table?

496

---

How do I count duplicates in sql?

534

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

497

---

What is materialized view in sql?

453

---

Can we join 3 tables in sql?

481

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1696

---

how many groups of data types? : Sql dba

555

---

How can triggers be used for the table auditing?

584

---