Answer Posted / mohan.s

First normal form (1NF) lays the groundwork for an
organised database design:

• Ensure that each table has a primary key: minimal
set of attributes which can uniquely identify a record.

• Eliminate repeating groups (categories of data
which would seem to be required a different number of times
on different records) by defining keyed and non-keyed
attributes appropriately.

• Atomicity: Each attribute must contain a single
value, not a set of values.

• 'First normal form' depends on functional
dependency formula f(x)=y. For every value of x there is
value for y.

List down the data types in the db2 database.

1115

---

Explain in detail about buffer manager and its functionalities?

1063

---

On which levels locks can be applied?

1123

---

What is lock escalation in db2?

1029

---

What are bind parameters in db2?

1044

---

What is the difference between bind and rebind in db2?

1447

---

What r the comman abends in db2, jcl and cobol???????

2250

---

What is the use of with ur in db2?

1052

---

What is dbrm in db2 database?

1108

---

How to check sequence on a table in db2?

1054

---

How do I add a column to an existing table in db2?

1030

---

What is commit in db2?

1050

---

What is dbrm? When it will be created?

1022

---

How is deadlock resolved?

1146

---

List some fields from sqlca?

1056

---