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

Explain the use of tables option in exp command.

1119

---

How to bring a tablespace offline?

1067

---

Explain the use of rows option in imp command.

1087

---

What is index in Oracle?

1076

---

How to sort output in descending order in oracle?

1047

---

What is flashback in Oracle?

1023

---

How to start your 10g xe server?

1046

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3053

---

What are the set operators union, union all, minus & intersect meant to do?

989

---

Explain an index?

1140

---

What are the most common interview questions on ETL Testing for experience?

1145

---

How to convert character types to numeric types?

1139

---

Is there any function in oracle similar like group_concat of mysql?

1057

---

What do you mean by merge in oracle?

996

---

How to join two tables in a single query using oracle?

1000

---