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

Can we store pictures in the database and if so, how it can be done?

981

---

How to load a large xml file?

1001

---

What is oracle open database communication (odbc)?

957

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1813

---

Give the advantages and disadvantages of clusters.

993

---

Describe varray?

1004

---

What is a trigger and what are its types?

1110

---

Explain drop constraint oracle?

988

---

What is the database name in oracle?

967

---

How to check your oracle database 10g xe installation?

923

---

Is it possible to insert comments into sql statements return in the data model editor ?

2507

---

Which environment variables are absolutely critical in order to run the OUI?

2067

---

What is connection pooling in oracle?

910

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

---

How to write a left outer join with the where clause in oracle?

1022

---