×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
What will collect information about dynamic and static SQL statements?
2.
The event monitor for transactions has been replaced in DB2 9.7 with which tool?
3.
Which method may be used to collect deadlock information in DB2 9.7?
4.
Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?
5.
A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design Advisor?
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design Advisor?
6.
You are running a LOAD utility and have not provided an exception table. What will happen if duplicates for a unique key get Inserted during the LOAD phase due to duplicates in the input file?
7.
Which command will reorg all indexes for a table named TABA?
8.
When are packages automatically rebound?
9.
A file named db2advise.in contains the following text:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT AVG(bonus), AVG(salary) FROM employee
GROUP BY workdept ORDER BY workdept;
Which command will cause the Design Advisor to make recommendations for a database named SAMPLE, using the information found in this file?
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT AVG(bonus), AVG(salary) FROM employee
GROUP BY workdept ORDER BY workdept;
Which command will cause the Design Advisor to make recommendations for a database named SAMPLE, using the information found in this file?
10.
Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF format. Which command(s) can be used to do this?