Answer / s

Root page is at topmost level of the index which has the
upper range values and pointers to non-leaf pages.

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

define clustering index.

0 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---

What is schema in db2?

0 Answers  

---

What does DML stand for and what are some examples of it?

3 Answers   IBM,

---

What is lock contention?

1 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,

---