Answer Posted / satya krishna

B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.

Indexes are logically and physically independent of the data in the associated table.

ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2285

---

How to get a list of all user accounts in the database?

1129

---

What are the types of trigger in oracle?

1026

---

What is the minimum client footprint required to connect c# to an oracle database?

1161

---

What is SQL access advisor in Oracle?

1228

---

How can we find out the current date and time in oracle?

1129

---

How to use windows user to connect to the server?

1043

---

What is a package ? What are the advantages of package ?

1136

---

How to use null as conditions in oracle?

1124

---

Is there any function in oracle similar like group_concat of mysql?

1104

---

What is bind variable in oracle 11g?

1094

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4414

---

What is a data lock in oracle?

1179

---

Can a formula column referred to columns in higher group ?

2550

---

How translate command is different from replace?

1138

---