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 an oracle database?

1111

---

What is hot backup and logical backup?

1114

---

How to define an anonymous procedure without variables?

1196

---

How to check your oracle database 10g xe installation?

1053

---

Which is better Oracle or MS SQL? Why?

5038

---

How can I combine multiple rows into a comma-delimited list in oracle?

1119

---

what is the use of system.effective.date variable in oracle?

1163

---

How to define and use table alias names in oracle?

994

---

What is dual table oracle?

1030

---

What is SQL access advisor in Oracle?

1231

---

Is there a function to split a string in plsql?

1109

---

what are the default admin accounts in Oracle 10g ?

1024

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2002

---

Can we save images in a database and if yes, how?

1113

---

What is hash cluster in oracle?

1250

---