Answer Posted / suresh somayajula

Index is used to solve some query fast.

we have 2 types of cursors.
1 Bitmap Index ( used only on Low cardinality columns)

2. Btree Index ( used only for High Cardinality of

columns)

How to resolve name conflicts between variables and columns?

985

---

How to add another datafile to a tablespace?

998

---

What are the database administrators utilities available?

983

---

Can multiple cursors being opened at the same time?

1024

---

How to compare dates in oracle sql?

1056

---

Where are the settings stored for each instance in oracle?

1071

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3159

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1710

---

What is a server parameter file in oracle?

1012

---

How to create a new view in oracle?

1020

---

What do you mean by a deadlock?

1018

---

what is dynamic SGA and static SGA

4340

---

How to experiment a data lock in oracle?

1006

---

What is the difference between alert log file and tarce file ?

2107

---

how to join query for one source type is oracle another source type is sql server ?

2388

---