《IBM DB2 97 DBA for Linux UNIX and Windows C2090-541题库》.pdf

s@lm@n IBM Exam C2090-541 DB2 9.7 DBA for Linux UNIX and Windows Version: 6.1 [ Total Questions: 102 ] 买题库 QQ:860424807 IBM C2090-541 : Practice Test Question No : 1 Which list of automatic maintenance parameters can have a policy defined to specify their automatic behavior? A. AUTO_DB_BACKUP, AUTO_RUNSTATS, AUTO_REORG B. AUTO_STMT_STATS, AUTO_DB_BACKUP, AUTO_RUNSTATS, AUTO_REORG C. AUTO_RUNSTATS, AUTO_REORG, AUT0_STMT_STATS D. AUTO_RUNSTATS, AUTO_STMT_STATS, AUTO_DB_BACKUP Answer: A Question No : 2 What are two available forms of compression in DB2 9.7? (Choose two.) A. column B. row C. page D. index Answer: B,D Question No : 3 You are running an IMPORT utility and have specified the option COMMITCOUNT AUTOMATIC Which two reasons will cause the IMPORT utility to COMMIT? (Choose two.) A. to avoid running out of active log space B. to avoid lock escalation from row level to table level C. to avoid allocation of secondary log files D. to avoid writing uncommitted data back to the database to make room in the buffer pool Answer: A,B 2 买题库 QQ:860424807 IBM C2090-541 : Practice Test Question No : 4 Which HADR feature minimizes the impact of software maintenance on the Standby server? A. Configure all AUTOMATIC features. B. Configure all AUTOMATIC maintenance parameters. C. Configure AUTOMATIC maintenance and perform a rolling upgrade D. Configure AUTOMATIC maintenance and perform a roll forward. Answer: C Question No : 5 Which method may be used to collect deadlock information in DB2 9.7? A. DEADLOCKS event monitor B. DB2DETAILDEADLOCK event monitor C. LOCKING event monitor D. DB2_CAPTURE_LOCKTIMEOUT registry v