Answer Posted / elbert gopta

An index is an additional auxiliary access structure used to speed up the retrieval of records in response to certain search conditions
An index enables efficient access to a record based on the indexing field or fields
An index is an ordered file with two fields consisting of the indexing field and the physical address of the record/block
Each table typically has a primary index created for the primary key of the table.

Types:
Primary Index
Secondary Index
Multilevel indexes
B-tree and B+-tree indexes

What is oracle and what are its different editions?

1068

---

Can you assign multiple query result rows to a variable?

993

---

Explain the use of full option in exp command.

1116

---

What is the max number of columns in an oracle table?

1001

---

Explain a segment?

1093

---

What is the use of file param in imp command?

1165

---

What is an oracle data file?

1105

---

How to pass parameters to procedures in oracle?

1042

---

What is ASM (Automatic Storage Management) in Oracle?

1198

---

what is normalisation?what are its uses?

2277

---

When system tablespace is created?

1046

---

what is the dual table in oracle?

996

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

---

How a tablespace is related to data files?

1109

---

How to select an oracle system id (sid)?

1064

---