How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

When do you specify the isolation level?

0 Answers  

---

What is a clustering index?

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,

---

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

What is a DB2 catalog?

2 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

What is normalization and what are the five normal forms?

1 Answers  

---

What is cursor stability?

1 Answers  

---