Answer Posted / anurag

EquiJoin
Non-equijoin
Outer join
Self join

What is open database communication (odbc) in oracle?

547

---

When do you get a .pll extension in oracle?

679

---

What is a named program unit?

580

---

What is a package in oracle?

562

---

What is the relation of a user account and a schema?

613

---

---

How to convert characters to times in oracle?

595

---

What are the attributes of the cursor?

557

---

What is set verify off in oracle?

577

---

How to do a full database export?

635

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1602

---

Explain cascading triggers.

574

---

Explain the use of constraints option in exp command.

562

---

Can we create trigger on materialized view in oracle?

565

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1605

---

How many categories of data types in oracle?

605

---