what is the Foreign key? explain?

2 Answers  

---

What is the use of runstats in db2?

0 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is bind package and plan in db2?

0 Answers  

---

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

What is a clustered index?

1 Answers  

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

What is a correlated sub query?

2 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

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  

---