Answer Posted / sudev kuma rmishra

two types
A.implicit B.explicit

A.implicit index

automatically created when we mention primary key or unique key

B.explicit index

these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index

How to speed up webrick?

1071

---

How to rename a tablespace in oracle?

1083

---

How to convert numbers to characters in oracle?

1027

---

What is a user role in oracle?

1116

---

What are the attributes of the cursor?

998

---

Explain the use of ignore option in imp command.

1033

---

Can we create database in oracle using command line ?

1080

---

What is index-organized table in Oracle?

1067

---

How to create an initialization parameter file?

1040

---

Can we commit inside a function in oracle?

960

---

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

1068

---

how do u setup a replication site?

1979

---

How to use "for" statements in oracle?

1072

---

Explain alias?

1133

---

What are the types of trigger in oracle?

974

---