Answer Posted / shankar

1.B-tree indexes:
B-tree indexes have the following subtypes:
Index-organized tables
Reverse key indexes
Descending indexes
B-tree cluster indexes
2.Bitmap and bitmap join indexes
3.Function-based indexes
4.Application domain indexes

Difference between oracle's plus (+) notation and ansi join notation?

1106

---

What is oracle analytical function?

1146

---

Why do you use stored procedures and state some of its disadvantages?

1028

---

What suggestions do you have to reduce the network traffic?

962

---

List out the difference between commit, rollback, and savepoint?

1033

---

Can we store pictures in the database and if so, how it can be done?

1045

---

How to create a single index for multiple columns?

1038

---

What is the difference between truncate & delete command?

1184

---

What is oracle host variable?

1066

---

What is oracle used for?

1026

---

How do I call oracle stored procedures that take no parameters?

1117

---

How to create a new table in your schema?

1081

---

How to drop an existing view in oracle?

946

---

Explain oracle 12c new features for developers?

1059

---

What are the uses of a database trigger?

994

---