what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

Explain what are the various isolation levels possible?

0 Answers  

---

Can you Average the Characters ?

3 Answers  

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

What can the Locate option of the Repair Utility accomplish?

2 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 difference between alias and synonym in db2?

0 Answers  

---

What is runstats utility in db2?

0 Answers  

---

What is index cardinality?

3 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

What is a SELECT statement?

1 Answers  

---

How does a cursor work?

0 Answers  

---