Answer Posted / siva

There are four reguler types of Indexes in oracle
1.Normal index
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.

The custom and recommended types are of 2 types
Implicit index and Explicit index.

What is bulk load in oracle?

1126

---

How to Truncate Table in Oracle

1213

---

What is a trigger and what are its types?

1328

---

does the query needs a hint to access a materialized view?

1905

---

How do I limit the number of oracle database connections generated by weblogic server?

1116

---

When do you get a .pll extension in oracle? Explain its importance

1098

---

Can we write insert statement in function in oracle?

1156

---

how the indexes are stored in the Oracle Database?

2334

---

How to use regular expression in pattern match conditions in oracle?

1075

---

How to import one table back from a dump file?

1085

---

What is an anonymous block?

1324

---

What are ddl statements in oracle?

1128

---

What is a sub query? What are its various types?

1275

---

types of indexes and the rationale behind choosing a particular index for a situation.

2559

---

What is the relationship among database, tablespace and data file?

1038

---