1. what is a reverse key index and it's real time usage 2. Difference Between Hash Join & Merge Join 3. Difference between Optimizer=ALL_ROWS and Optimizer=CHOOSE 4. What is the meaning of cost, card, Bytes? 5. What is syntax for dropping a procedure and a function .Are these operations possible? 6. How you were passing cursor variables in PL/SQL 2.2? 7. What should be the return type for a cursor variable.Can we use a scalar data type as return type? 8. What is use of a cursor variable? How it is defined?
-
Interview Candidate
- May 26th, 2007
- 0
- 3789
This Question is not yet answered!
1. what is a reverse key index and it's real time usage 2. Difference Between Hash Join & Merge Join 3. Difference between Optimizer=ALL_ROWS and Optimizer=CHOOSE 4. What is the meaning of cost, card, Bytes? 5. What is syntax for dropping a procedure and a function .Are these operations possible? 6. How you were passing cursor variables in PL/SQL 2.2? 7. What should be the return type for a cursor variable.Can we use a scalar data type as return type? 8. What is use of a cursor variable? How it is defined?
This Question is not yet answered!