×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?
2.
When does space reclamation for a column-organized table normally occur?
3.
What are the correct steps to capture EXPLAIN information for column-organized tables?
4.
If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which
two capabilities are available?
5.
Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?
6.
What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?
7.
When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?
8.
When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?
9.
What type of table can be converted into a column-organized table with the db2convert command?
10.
Which statement regarding NOT ENFORCED unique constraints is true?