Answer Posted / gaurav kukreja

mainly two type of indexes
1:- logical
2:- physical
logical indexes are also two type.. uniqe and functional
based indexes.
functional indexes are also two type...b-treeand bit map
indexes....

indexes are also used in searching and sorting

What is rowid and rownum in oracle?

1007

---

How to get last row id?

985

---

Can we write insert statement in function in oracle?

1081

---

What are the common oracle dba tasks?

1139

---

How to use windows user to connect to the server?

986

---

how may join possible between (requisition with purchase order)

2241

---

What is oracle thin client?

1021

---

what are bitmap indexes? How does they work?

2233

---

Can multiple cursors being opened at the same time?

1056

---

What is a table index in oracle?

1125

---

How do I manually uninstall oracle client?

1082

---

What is a tns file?

988

---

How to sort the query output in oracle?

1023

---

What is columnar storage what is the advantage?

1054

---

Explain the use of consistent option in exp command.

1059

---