Answer / orawhiz

yeah

Answer / kannan

Sure

Answer / nishi

yes

How can we find the size of a database?

2 Answers  

---

Difference between sub query and nested query ?

19 Answers   Keane India Ltd, TCS,

---

waht is the difference between primary key and super key?

9 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,

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

---

what is the exact definition for pointer?

7 Answers   Wipro,

---

What is an anonymous block?

0 Answers  

---

What is the quickest way to fetch the data from a table?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

How to create an oracle database?

0 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

defination of bitmap index

0 Answers   NIIT,

---