Answer Posted / gouranga mohapatra

There are several types of indexes available in Oracle all
designed for different circumstances:
•b*tree indexes - the most common type (especially in OLTP
environments) and the default type
•b*tree cluster indexes - for clusters
•hash cluster indexes - for hash clusters
•reverse key indexes - useful in Oracle Real Application
Cluster (RAC) applications
•bitmap indexes - common in datawarehouse applications
•partitioned indexes - also useful for datawarehouse
applications
•function-based indexes
•index organised tables
•domain indexes

What is program global area (pga) in oracle?

954

---

How do I uninstall oracle client from windows?

956

---

How to convert a string to a date in oracle database?

999

---

How to recover a dropped table in oracle?

983

---

What is the meaning of recursive hints in oracle?

992

---

How do I connect to oracle?

974

---

What is null value in oracle?

1031

---

How do I spool to a csv formatted file using sqlplus?

963

---

What is set verify off in oracle?

1029

---

Explain integrity constraint?

1103

---

How do I spool in oracle?

937

---

What is pragma autonomous transaction in oracle?

989

---

How to create a stored function in oracle?

1036

---

How do you store pictures in a database?

946

---

How to lock and unlock a user account in oracle?

1024

---