×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
The UNLOAD utility can be used to do which of the following functions?
2.
A table space is in AREO*. What does this status mean?
3.
For monitoring space growth over time, which statistics should NOT be considered?
4.
The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?
5.
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
6.
Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this is not occurring?
7.
In order to properly monitor locks on a continual basis, which action should be performed but will avoid using
excessive CPU resources to gather the information?
excessive CPU resources to gather the information?
8.
When is a merge scan join a well performing access path?
9.
When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?
10.
Which DB2 performance feature is designed specifically to reduce the number of indexes that need to be created?