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 tns name?

934

---

Explain a synonym?

983

---

How to define an anonymous block?

1091

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1911

---

How do I escape a reserved word in oracle?

1144

---

Explain about functional dependency and its relation with table design?

966

---

Can multiple cursors being opened at the same time?

1026

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1051

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2911

---

What privilege is needed for a user to create tables in oracle?

915

---

how to clone 9i Database on to 10g Database.

2299

---

How to delete an existing row from a table in oracle?

1025

---

Can we store images in oracle database?

954

---

How to install oracle odbc drivers?

1050

---

please explain.. DB architecture ...

1979

---