|
Related Questions |
View Answer |
|
88) What is QUIESCE?
|
View Answer
|
|
87) What is CHECK PENDING ?
|
View Answer
|
|
86) What is COPY PENDING status?
|
View Answer
|
|
85) When do you use the IMAGECOPY? �
|
View Answer
|
|
84) What is IMAGECOPY ? �
|
View Answer
|
|
83) What is REORG? When is it used?
|
View Answer
|
|
82) Give some example of statistics collected during RUNSTATS?
|
View Answer
|
|
81) When will you chose to run RUNSTATS?
|
View Answer
|
|
80) What is RUNSTATS? �
|
View Answer
|
|
79) How do you insert a record with a nullable column?
|
View Answer
|
|
78) What does it mean if the null indicator has -1, 0, -2? �
|
View Answer
|
|
77) What is the picture clause of the null indicator variable? �
|
View Answer
|
|
76) How do you retrieve the data from a nullable column? �
|
View Answer
|
|
75) How does DB2 store NULL physically?
|
View Answer
|
|
74) Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened? �
|
View Answer
|
|
73) When is the access path determined for dynamic SQL? �
|
View Answer
|
|
72) What is dynamic SQL ? �
|
View Answer
|
|
71) Lot of updates have been done on a table due to which indexes have gone haywire. What do you do? �
|
View Answer
|
|
70) How do you pull up a query which was previously saved in QMF ? �
|
View Answer
|
|
69) How would you print the output of an SQL statement from SPUFI? �
|
View Answer
|