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.

What is the role of data manager in the db2 database?

1109

---

How would the varchar column remarks defined?

1088

---

How do I delete a table in db2?

1073

---

What are the full forms of spufi and dclgen and why are they used?

1089

---

How to view db2 table structure?

1018

---

Which command is used to remove all rows from a table?

1111

---

What is a db2 cursor?

1055

---

How do you find the maximum value in a column in db2?

1107

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8292

---

How can you find out the # of rows updated after an update statement?

1116

---

What is a plan and package in db2?

1104

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1737

---

What is buffer pool in the db2 database?

1107

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2388

---