Answer Posted / gaurav kukreja

mainly two type of indexes
1:- logical
2:- physical
logical indexes are also two type.. uniqe and functional
based indexes.
functional indexes are also two type...b-treeand bit map
indexes....

indexes are also used in searching and sorting

How do I start tns listener?

1051

---

How to use windows user to connect to the server?

990

---

What are the extensions used by oracle reports?

1040

---

Describe an oracle table?

1055

---

What is primefaces used for?

1052

---

List out the types of joins.

1164

---

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

2173

---

How to get the Installed Oracle Version Information ?

1128

---

How to write text literals in oracle?

1070

---

What is a cursor in oracle?

1181

---

Explain an exception?

1003

---

What is archive log in Oracle?

1135

---

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

1098

---

How to initialize variables with default values?

1250

---

Can group functions be used in the order by clause in oracle?

999

---