Answer Posted / swapna

We have mainly two different indexes .

Implicit index and Explicit index.

Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4480

---

what are actual and formal parameters?

1057

---

Define oracle database

1000

---

State and explain about oracle instance?

940

---

what is the scenario where you take the database to NoArchivelog mode?

2269

---

how to join query for one source type is oracle another source type is sql server ?

2388

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1005

---

How can I create database in oracle?

964

---

How to define a data source name (dsn) in odbc manager?

974

---

Explain self joins in oracle?

954

---

Explain an index?

1102

---

When do we use group by clause in a sql query?

999

---

is there a tool to trace queries, like profiler for sql server?

1088

---

What is system tablespace?

1050

---

What is the difference between Delete, Truncate and Drop in Oracle?

1077

---