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 are the different types of synonyms?

839

---

What are the data types in oracle?

783

---

What privilege is needed for a user to delete rows from tables in another schema?

795

---

What is the difference between alert log file and tarce file ?

1866

---

How to convert dates to characters in oracle?

783

---

How do we represent comments in oracle?

836

---

How to run create database statement?

776

---

how do u setup a replication site?

1716

---

How to convert raw data type into text in oracle? Explain

806

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1950

---

How do I recompile a procedure in oracle?

736

---

How to create a testing table in oracle?

765

---

How many memory layers are in the oracle shared pool?

865

---

How to run queries on external tables?

801

---

How to establish administrator authentication to the server?

789

---