Answer Posted / gnskannan

Indexes in Oracle are as follows.....

1.Normal index
Whenever we created a column(s) with Primary key or
Unique constraints ,Oracle implicitly creates Normal
index.This index is not Unique index .Why because those
columns already having uniqeness because of Unique or
Primary key constriants.

2.Bitmap indexs
3.Function based indexs
4.Domain indexes.
if we want to create Unique indexes we have to use Unique
keyword when we are creating indexes.

But if you refer Oracle 9i corporation books you can read
as follows...

They gave these statement in wrong.

Indexes can be created in two types

1.Unique indexes(Oracle creates it implicitly whenever we
created column(s) with PK or Unique constraints

2. Non unique indexes
This indexes can be created by developers

What is connection pool in oracle?

926

---

Explain the use of log option in exp command.

1043

---

Why use resource manager in Oracle?

1049

---

How to create an initialization parameter file?

979

---

What is a parameter file in oracle?

1048

---

What is the exact use of Collections?

2094

---

Explain a segment?

1017

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2195

---

Why do we need oracle client?

881

---

What is the use of file param in imp command?

1112

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2205

---

What is meant by joins?

1011

---

 How to use an oracle sequence generator in a mapping?

1016

---

How to get execution path reports on query statements?

926

---

What is literal?

953

---