Answer Posted / sudev kuma rmishra

two types
A.implicit B.explicit

A.implicit index

automatically created when we mention primary key or unique key

B.explicit index

these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index

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

971

---

How do I start tns listener?

987

---

What is oracle join syntax?

941

---

Explain about integrity constraint?

1076

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2145

---

How to retrieve values from data fields in record variables?

1033

---

How to initialize variables with default values?

1157

---

please explain.. DB architecture ...

1966

---

What is an Oracle index?

1602

---

How to experiment a data lock in oracle?

999

---

How to create a stored program unit?

1115

---

What is a proxy object?

1008

---

How to create a stored function in oracle?

1036

---

Can objects of the same schema reside in different tablespace?

1000

---