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,

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

---

What does sqlcabc has?

0 Answers  

---

Why cursor is used in db2?

0 Answers  

---

Write a query to retrive partial string.

2 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---