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

Explain an extent?

1158

---

how may join possible between (requisition with purchase order)

2331

---

What are the uses of Database Trigger ?

1789

---

Explain table?

1178

---

What is ordinary table in oracle?

1243

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2038

---

Can you have more than one content canvas view attached with a window ?

2373

---

How to use select statement to count the number of rows in oracle?

1094

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2043

---

How do I find my oracle client driver version?

1098

---

Who developed oracle & when?

1059

---

How do I uninstall oracle client from windows?

1060

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1748

---

How to filter out duplications in the returning rows using oracle?

1068

---

What is proxy method?

1025

---