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 the difference between hot backup and cold backup in oracle? Tell about their benefits also.

937

---

How do I manually uninstall oracle client?

1044

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2786

---

How can you use check constraints for self referential integrity?

933

---

How to sort output in descending order in oracle?

999

---

Briefly explain what is literal? Give an example where it can be used?

993

---

What is Library Cache in Oracle?

1096

---

Explain constraining triggers.

1055

---

How to create a temporary table in oracle?

1220

---

what is the scripts in data base?

2099

---

Explain the use of indexes option in imp command.

1117

---

How to assign values to data fields in record variables?

992

---

Can we use bind variables in oracle stored procedure?

918

---

Explain a segment?

1046

---

Explain index?

1221

---