what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

Define predicate?

0 Answers  

---

What is the physical storage length of time data type?

0 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---