Answer / s

The no of distinct values for a given column.

Answer / prabhavathi p

A sequential arrangement of material.
directs attention to some fact, condition;

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What is cursor with hold option in db2?

0 Answers  

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

What is table space in db2?

0 Answers  

---

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

2 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

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,

---