Answer / ramprasad.s

Hi

Indexes in oracle are to retrieve the data from the
database at a faster rate

bye
sun_ramprasad@yahoo.com

Answer / basanti

Hello

Index is a database object which is use to access data
faster its like content page in a book

Answer / radha

Indexes in Oracle are:

(create <type of index> index <indexname> on <tablename>
(<colname>)

1. B-Tree (regular indexing algorithm )
2. Bitmap (for low cardinality fields.
By default oracle creates bitmap Index)
3. Partitioned indexes (for manageability
and to distribute I/O evenly)
4. Function based indexes (when you want
to index a function based calculation itself)
5. IOTs (Index organised tables - Table and
Index combined into one)
6. Domain Indexes (using user defined index types)

How to concatenate two text values in oracle?

0 Answers  

---

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

0 Answers  

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

What is a Data Segment ?

3 Answers  

---

What is a Garbage Collection? and what is full recursive Garbage collection?

0 Answers   RBS,

---

What is partitioned table in Oracle?

0 Answers   MCN Solutions,

---

What is a trigger and what are its types?

0 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

---

Where do we use decode and case statements?

0 Answers  

---

What is the data pump import utility?

0 Answers  

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---