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,

---

What is lock contention?

1 Answers  

---

How to execute stored procedure in db2 command editor?

0 Answers  

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

What is a trigger in the db2 database?

0 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What is lock escalation in db2?

0 Answers  

---

Which component is responsible for db2 startup and shutdown?

0 Answers  

---