Answer / Saket Shukla

DB2 isolation levels define the degree of consistency between transactions. There are five isolation levels: READ UNCOMMITTED (0), READ COMMITTED (1), REPEATABLE READ (2), SERIALIZABLE (3), and SNAPSHOT (4). Each level offers varying levels of concurrency control and data consistency.

Differentiate between cs and rr isolation levels? Where do you specify them?

1 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

Can you use max on a char column?

1 Answers  

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

How to rename a table in DB2 ?

1 Answers   MCN Solutions,

---

Is it possible using max on a char column?

1 Answers  

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1 Answers  

---

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

2 Answers  

---

What is the use of dclgen in db2?

1 Answers  

---

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

4 Answers  

---