What happens to the PLAN if index used by it is dropped?

1 Answers  

---

What is the function of the Data Manager?

2 Answers  

---

How many buffer pools are available in db2?

2 Answers  

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

Return code 100 means?

6 Answers   Cap Gemini,

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

Which is faster delete or truncate?

0 Answers  

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

what is a collection?

2 Answers  

---