Answer / s

Writes are queued until a commit, checkpoint happens. Also
when write thresholds are exceeded, stop database, stop db2.

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

How do you define a correlated name?

1 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

When will you chose to run RUNSTATS?

1 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

What do you mean by storage group (stogroup)?

0 Answers  

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

Explain the use of the WHERE clause.

2 Answers   IBM,

---