×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
What is the minimum buffer pool page size for a compressed index?
2.
What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?
3.
Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections?
4.
Which technique can be utilized for the reporting of real-time statistics?
5.
You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares?
6.
DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an objects RBA remains in basic 6-byte format. What processing is NEVER allowed?
7.
You have defined the array type PHONENUMBERS using the following DDL:
CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];
You also defined a variable named RECENT_CALLS based on this new array type as follows:
CREATE VARIABLERECENT_CALLS PHONENUMBERS:
Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?
CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];
You also defined a variable named RECENT_CALLS based on this new array type as follows:
CREATE VARIABLERECENT_CALLS PHONENUMBERS:
Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?
8.
Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES?
9.
What catalog table provides the information about missing or conflicting catalog statistics for SQL statements?
10.
When would DB2 NOT use list prefetch?