Answer / vamsikrishnamraju

A foreign key is a referential constraint between two
tables.The foreign key identifies a column or a set of
columns in one (referencing) table that refers to a column
or set of columns in another (referenced) table. The
columns in the referenced table must form a primary key or
unique key.

What do you mean by cursor?

0 Answers  

---

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

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

0 Answers   IBM,

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

Explain the contents that are a part of dclgen.

0 Answers  

---

How does one remove entries from the SCT02 table?

1 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

Explain an outer join?

1 Answers  

---