Answer / s

CS - page or row locks are released as soon as the cursor
is moved to another row or page.

RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

What is runstats db2?

0 Answers  

---

Mention the different locking levels that are available in db2.

0 Answers  

---

Is schema the same as database?

0 Answers  

---

How do I add a column to a table in db2?

0 Answers  

---

List down the data types in the db2 database.

0 Answers  

---

What is database reorganization?

0 Answers  

---

what is different three logs in DB2?

1 Answers   Syntel,

---

Update command

1 Answers  

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---