What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

1 Answers   HDFC,

---

What is a Data Segment ?

3 Answers  

---

Where do you use decode and case statements?

0 Answers  

---

How index is implemented in oracle database?

0 Answers  

---

Give the various rollback segment states.

0 Answers  

---

Can a Tablespace hold objects from different Schemes ?

3 Answers  

---

Why is oracle database so popular?

0 Answers  

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

0 Answers  

---

Tell me New Feature of Oracle 10g?

5 Answers   Thermotech,

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

What is meant by recursive hints ?

1 Answers  

---

What is dual table oracle?

0 Answers  

---