IBM DB2 9.7 Advanced DBA for LUW - 000-544무료 덤프문제 풀어보기
What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
정답: A,D
Which two operators would indicate inter-partition parallelism in an Optimizer Plan? (Choose two.)
정답: A,C
Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?
정답: C
A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?
정답: C
Your UNIX system administrator has indicated that there appears to be a lot of I/O wait time associated with your database, which is stored in a 7+p RAID array. An investigation reveals the following information: DB2_PARALLEL_IO=*
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64.
Which setting would optimize I/O for the largest table?
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64.
Which setting would optimize I/O for the largest table?
정답: B
Which command CANNOT be used to explicitly build a compression dictionary for a table?
정답: D
A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
정답: A
If LOGSECOND=-1 then which of the following statements is true?
정답: D