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 check the oracle tns settings?

1090

---

How many file formats are supported to export data?

1269

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2362

---

what is the dual table in oracle?

1041

---

How to assign data of the deleted row to variables?

1118

---

Explain the use of inctype option in exp command.

1083

---

What do you know about normalization? Explain in detail?

1004

---

What is oracle instant client?

1070

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2247

---

Can a formula column be obtained through a select statement ?

2380

---

What is a nvl function? How can it be used?

1099

---

types of indexes and the rationale behind choosing a particular index for a situation.

2560

---

How to assign query results to variables?

1098

---

State some uses of redo log files?

1068

---

Explain coalesce function?

1251

---