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  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

What are the three lock types?

2 Answers  

---

What is the default page size of buffer pools?

0 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---

What is a LIKE table and how is it created?

2 Answers  

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

What is an intent lock?

3 Answers  

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---