Answer Posted / swapna

We have mainly two different indexes .

Implicit index and Explicit index.

Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.

How many types of database triggers exist?

1135

---

How to save query output to a local file?

1026

---

Can objects of the same schema reside in different tablespace?

1062

---

What is ASM (Automatic Storage Management) in Oracle?

1196

---

Is primary key indexed by default in oracle?

987

---

Difference between cartesian join and cross join?

1046

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2467

---

How to use "while" statements in oracle?

1327

---

Give the constructs of a package, function or a procedure.

1045

---

What are oracle functions?

1030

---

What are the predefined tablespaces in a database?

1082

---

Can you tell me how to add new column in existing views?how?How is possible?

1448

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

---

How to export your connection information to a file?

1133

---