Answer Posted / ankur jain

An Index is nothing, it is something like the index behind in your text book, using index we can find any topic in our text book very fast,, hence database index is also like that, oracle engine uses this index to find any particular row quickly..
This is automatically created when you create the primary key during creation of table..

How to display employee records who gets more salary than the average salary in the department?

1126

---

What do you mean by merge in oracle and how can we merge two tables?

1095

---

What is columnar storage what is the advantage?

1120

---

What is max rowid in oracle?

1081

---

What is dual table oracle?

1029

---

How to fetch the row which has the max value for a column?

1044

---

Does facebook use oracle?

1081

---

what happened to the global index when I truncate the data in one of the partition?

2066

---

What's dateware house and what's clustor with practicle example

2233

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

---

What are the major difference between truncate and delete?

1131

---

How to execute a stored procedure in oracle?

1147

---

Oracle

2422

---

What are the attributes that are found in a cursor?

1120

---

How to retrieve data from an explicit cursor?

1105

---