Answer Posted / siva

There are four reguler types of Indexes in oracle
1.Normal index
2.Bitmap indexs
3.Function based indexs
4.Domain indexes.

The custom and recommended types are of 2 types
Implicit index and Explicit index.

What is raw datatype in oracle?

849

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2411

---

How to check your oracle database 10g xe installation?

774

---

How to create a table in a specific tablespace?

766

---

Difference between cartesian join and cross join?

802

---

How to delete all rows a table in oracle?

839

---

Does oracle partitioning improve performance?

775

---

What is the exact use of Collections?

1932

---

How oracle handles dead locks?

838

---

What is the oracle implicit cursor?

827

---

When system tablespace is created?

811

---

Give the different types of rollback segments.

828

---

What do you understand by database schema and what does it hold?

963

---

What is difference between truncate and delete?

765

---

How to use subqueries in the from clause in oracle?

859

---