Answer / s

primary key, foreign key, Joins are often performed on
primary and foreign key columns. columns frequently coded
in the WHERE clause, ORDER BY, GROUP BY, DISTINCT, columns
which are searched or joined over less than 5-10% of the
rows.

How do you insert a record with a nullable column?

2 Answers  

---

What is query_cache_limit?

0 Answers  

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

What are the various locks available?

5 Answers   CTS,

---

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

---

How is deadlock resolved?

0 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

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

0 Answers   MCN Solutions,

---

what is SPUFI ?

2 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

List out the three types of page locks that can be held.

0 Answers  

---