|
Related Questions |
View Answer |
|
92) What is sqlcode -922 ?
|
View Answer
|
|
91) What is the difference between primary key & unique index ?
|
View Answer
|
|
90) How many clustering indexes can be defined for a table?
|
View Answer
|
|
89) What is a clustering index ? �
|
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
|