Answer / guest

The Optimizer chooses Cost_based approach and optimizes with
the goal of best throughput if statistics for atleast one of
the tables accessed by the SQL statement exist in the data
dictionary. Otherwise the OPTIMIZER chooses RULE_based
approach.

Answer / nishi

The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

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 should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

---

can a table has a column that has only view data and in other columns we can change data?

2 Answers   Secon,

---

---

How to use "in out" parameter properly?

0 Answers  

---

What is a nested table and how is it different from a normal table?

0 Answers  

---

Is oracle a programming language?

0 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

What is the CAP theorem?

1 Answers  

---

what is the difference between simple view and complex view?

13 Answers  

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---