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.

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

Name the lockable units in DB2?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

---

Name the different types of Table spaces.

5 Answers   IBM,

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

What are the three types of page locks that can be held?

1 Answers  

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

Can we delete records from view?

0 Answers  

---

How many databases are there?

0 Answers  

---

What is pagespace?

1 Answers  

---