wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

Return code 100 means?

6 Answers   Cap Gemini,

---

what is rebinding ?

1 Answers   IBM,

---

How do you retrieve the data from a nullable column?

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 the difference between where clause and having clause

2 Answers   IBM,

---

Can we delete records from view?

0 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---