|
Question |
Rating |
View Answer |
|
102) What is index cardinality? � |
|
View Answer |
|
101) What is filter factor? |
|
View Answer |
|
100) What are simple, segmented and partitioned table spaces ? |
|
View Answer |
|
99) What is FREEPAGE and PCTFREE in TABLESPACE creation? |
|
View Answer |
|
98) What is an inner join, and an outer join ? |
|
View Answer |
|
97) What are the 4 environments which can access DB2 ? |
|
View Answer |
|
96) If I have a view which is a join of two or more tables, can this view be updateable? � |
|
View Answer |
|
95) Are views updateable ? |
|
View Answer |
|
94) What does the sqlcode of -818 pertain to? � |
|
View Answer |
|
93) What is sqlcode -811? |
|
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 |