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

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2064

---

How do we get field detail of a table?

1032

---

How to calculate date and time differences in oracle?

1001

---

How to do a full database export?

1059

---

What do you mean by merge in oracle?

946

---

what happened to the global index when I truncate the data in one of the partition?

1975

---

is there a tool to trace queries, like profiler for sql server?

1098

---

What are the various constraints used in oracle?

1001

---

What is oracle host variable?

999

---

What privilege is needed for a user to delete rows from tables in another schema?

1029

---

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1880

---

What is hot backup and logical backup?

1010

---

How can I combine multiple rows into a comma-delimited list in oracle?

1013

---

Can a formula column referred to columns in higher group ?

2469

---

Explain how are indexes update?

1033

---