×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
2.
What must be done to convert a populated base table to a multidimensional clustering (MDC) table?
3.
Which command(s) should be used to drop database partition 10 from a database named MYDB?
4.
What statement regarding Asynchronous index cleanup (AIC) is correct?
5.
If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?
6.
A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ? db2fs1? ? db2fs2? '/db2fs3' Then, a table space named TS1 was created in the storage group and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had been consumed. So, more space was added to the storage group by executing the following command: ALTER STOGROUP med_sg ADD ? db2fs4? ALTER STOGROUP med_sg ADD ?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower. Which statement should be executed to correct the performance problem?
7.
Which would not significantly benefit from having the RUNSTATS command run on it?
8.
Which tool provides the simplest method for monitoring buffer pool hit ratios?
9.
Which is NOT a valid method for prefetching data?
10.
The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?