×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?
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.
Which statement is NOT true?
5.
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?
6.
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
7.
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?
8.
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?
9.
The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be used to gather the I/O information needed for the objects in database NEWBILL?
10.
When is a merge scan join a well performing access path?