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,

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

What is a user role in oracle?

0 Answers  

---

What is instant client oracle?

0 Answers  

---

What is OCI. What are its uses?

1 Answers  

---

---

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers   Wipro,

---

Do View contain Data ?

10 Answers  

---

What is meant by recursive hints ?

1 Answers  

---

Explain parameter file in oracle.

0 Answers  

---

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

---

What is the difference between a hot backup and a cold backup in oracle?

0 Answers  

---

What the is the diff between local index and global index. give some example.

0 Answers   TCS,

---