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

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2053

---

Name the various constraints used in oracle?

1011

---

How to load data from external tables to regular tables?

1056

---

How to create lov dynamically at runtime & attach to text field?

1156

---

How to create a new user account in oracle?

1007

---

How to get a list of all background sessions in the database?

988

---

What is the use of oracle?

1027

---

What are the ansi data types supported in oracle?

942

---

 What are the oracle DML commands possible through an update strategy?

1054

---

what happened to the global index when I truncate the data in one of the partition?

2012

---

Explain how you would restore a database using RMAN to Point in Time?

2136

---

What to do if dba lost the system password?

1162

---

interview questions with answer for cts

2578

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

965

---

What is a oracle database?

1048

---