State and explain about oracle instance?

0 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

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 are the uses of synonyms?

0 Answers  

---

what is the syntax of ALTER command?

8 Answers  

---

---

What is oracle analytical function?

0 Answers  

---

what is shell?

2 Answers   Microsoft,

---

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

State the difference between a primary key and foreign key?

0 Answers  

---

How to compare dates in oracle sql?

0 Answers  

---

What is an oracle recycle bin?

0 Answers  

---

What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  

---