Answer Posted / satya krishna

B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.

Indexes are logically and physically independent of the data in the associated table.

ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.

Explain the dml?

928

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2160

---

How to export data with a field delimiter?

980

---

Differentiate between post-database commit and post-form commit?

987

---

What is Redo Log Buffer in Oracle?

1144

---

Who developed oracle & when?

956

---

What is the maximum number of triggers that can be applied to a single table?

965

---

How to drop a stored procedure in oracle?

1008

---

How to insert multiple rows with one insert statement in oracle?

1031

---

How to change system global area (sga) in oracle?

967

---

How to update a table row with a record?

970

---

What is a trace file and how is it created in oracle?

990

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2083

---

Give the advantages and disadvantages of clusters.

1004

---

Why do we use bulk collect in oracle?

1019

---