Answer / guest

Index is used for fast retrieving of data from table.

Answer / mohan

With the help of index we can access the data quickly from
the table....

Answer / rad

An index is an oracle object that stores ROWID (pointer)
and columns(s) data on a source table. Two main types are
B-tree and Bitmap. An index is crucial as it can preempt
unnessessary full table scans on the source table if the
queried data is included the indexed column(s). B-tree
primarily useful in OLTP and Bitmap is DSS (generally..)

Answer / premsagar

Index is used to retrive the date from the table.i.e,. it
point's out the field's which we specify.......

What is the usage of analyze command in oracle?

0 Answers  

---

How to use "in" parameter properly?

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

What is Java Pool in Oracle?

0 Answers   MCN Solutions,

---

How to create a new oracle data file?

0 Answers  

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

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,

---

what is the difference between substr and instr function in oracle?

0 Answers  

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---

What privilege is needed for a user to connect to oracle server?

0 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---