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.

Name the various locking levels available?

1081

---

Why cursor is used in db2?

1022

---

What is db2 instance?

1057

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1044

---

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

1094

---

What are the two types of logging in the db2 database? Explain them.

1055

---

List out the data types available.

1131

---

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

1012

---

Which isolation level provides maximum concurrency?

1141

---

What is the use of with ur in db2?

1035

---

Can we insert update delete in view?

949

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1066

---

Explain various types of locks in db2?

1127

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1255

---

Is db2 free?

1077

---