Answer / mathavan

Indexes are used for faster access of required data in a
large table.

Answer / rajesh naidu

INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

what is the use of home directory???

1 Answers   HP,

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

how can you record information about current session?

0 Answers   Oracle,

---

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

1 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---