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

How to handle a single quote in oracle sql?

1062

---

What is a nested table?

1071

---

How do I limit the number of oracle database connections generated by weblogic server?

1074

---

Use of an integrity constraint is better to validate data. Explain

1046

---

How can I introduce multiple conditions in like operator?

993

---

Give the various rollback segment states.

1057

---

How oracle handles dead locks?

1077

---

Can you have more than one content canvas view attached with a window ?

2333

---

What is blob data type in oracle?

1128

---

What is the quickest way to export a table to a flat file?

970

---

How do I find the database name in oracle?

1044

---

What are the types of partitions in oracle?

1039

---

How to connect ms access to oracle servers?

1014

---

How would you go about verifying the network name that the local_listener is currently using?

2053

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2311

---