Answer Posted / raj&

materialized views are schema objects that can be used to summarize,precompute,replicate and distribute data.

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

804

---

What are the two virtual tables available at the time of database trigger execution?

631

---

What is a join query?

546

---

how is myisam table stored? : Sql dba

603

---

What is trigger types of trigger?

550

---

---

What is difference between my sql and sql?

528

---

What is the difference between an inner and outer join?

537

---

What is fmtonly in sql?

527

---

What are data types in pl sql?

559

---

Is sql difficult?

743

---

what are the differences among rownum, rank and dense_rank? : Sql dba

536

---

Explain autonomous transaction.

632

---

How can you select unique records from a table?

518

---

Is primary key is clustered index?

527

---

How can I delete duplicate rows?

560

---