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.

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2212

---

How to login to the server without an instance?

1103

---

What is oracle thin client?

973

---

What is meant by an index?

1058

---

How can I combine multiple rows into a comma-delimited list in oracle?

999

---

Explain the use of record length option in exp command.

1021

---

How to convert a date to char in oracle? Give one example.

1001

---

What are ddl statements in oracle?

1014

---

How will you write a query to get a 5th rank student from a table student_report?

1813

---

How to export your own schema?

969

---

What is a parameter file in oracle?

1049

---

What is Virtual Private Database in Oracle?

1015

---

How to list all tables in your schema?

990

---

Give the various exception types.

943

---

How many types of segments in Oracle?

1012

---