Answer Posted / kiran

subquery can be used for simple logical queries , to get
required output/condition

but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins

Explain compound trigger in oracle?

988

---

What is the use of aggregate functions in oracle?

981

---

What is Segment Advisor in Oracle?

1051

---

What is a partition in oracle?

1039

---

Difference between hot backup vs. Cold backup?

949

---

What is the maximum number of triggers that can be applied to a single table?

956

---

What is a schema in oracle?

968

---

Can we store images in oracle database?

948

---

how the indexes are stored in the Oracle Database?

2214

---

How to store pictures on to the database?

923

---

How to see free space of each tablespace?

968

---

what is the difference between restoring and recovering?

965

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1047

---

Explain the use of analyse option in exp command.

1067

---

Does oracle partitioning improve performance?

947

---