how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

Explain the function done by data manager?

0 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

How can the duplicate values be eliminated from db2 select?

0 Answers  

---

What is coalesce in db2?

0 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,

---

How to find the maximum value in a column in the db2 database?

0 Answers  

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

What is an asychronous write?

1 Answers  

---