What is the difference between substr & instr functions?

0 Answers  

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

candidate key is subset of super key but not vice-verse explain

0 Answers  

---

What is Row Chaining ?

3 Answers   Cognizant, CTS,

---

Does oracle charge for java?

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

State all possible different index configurations a table can possibly have?

0 Answers  

---

Youre getting high busy buffer waits - how can you find whats causing it?

1 Answers  

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

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 meant by an index?

0 Answers  

---