How to write a query with an inner join in oracle?

0 Answers  

---

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,

---

Describe varray?

0 Answers  

---

What is a cluster Key ?

2 Answers  

---

Is java required for oracle client?

0 Answers  

---

---

What are the composite date types in oracle?

6 Answers   HCL,

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

What do you understand by a database object?

0 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

Give the advantages and disadvantages of clusters.

0 Answers  

---

Does oracle database need java?

0 Answers  

---

What is the difference between translate and replace?

0 Answers  

---