explain about index with examples

2 Answers   Syntel,

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

What is QUIESCE?

2 Answers  

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

---

what is plan? is plan executable or package?

4 Answers  

---

What is data manager?

0 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

What is filter factor?

2 Answers  

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---