文档详情

《IBM DB2 101 Advanced DBA for Linux UNIX and Windows C2090-614题库》.pdf

发布:2015-12-26约9.5千字共8页下载文档
文本预览下载声明
s@lm@n IBM Exam C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Version: 6.0 [ Total Questions: 108 ] 买题库 QQ:860424807 IBM C2090-614 : Practice Test Topic break down Topic No. of Questions Topic 1: Volume A 54 Topic 2: Volume B 54 2 买题库 QQ:860424807 IBM C2090-614 : Practice Test Topic 1, Volume A Question No : 1 - (Topic 1) In which situation would you NOT use a redirected restore? A. To redefine the paths of a defined storage group. B. To move table space containers onto different physical devices. C. To restore a backup image from one operating system to another. D. To restore a backup image to a target machine that is different from the source machine. Answer: C Question No : 2 - (Topic 1) What is the preferred method for reclaiming unused storage in a DMS table space? A. Perform an ALTER TABLESPACE...REDUCE operation. B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation. C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation. D. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation. Answer: C Question No : 3 - (Topic 1) Consider the following statement: Which indexes should be created for optimal query performance? 3 买题库 QQ:860424807 IBM C2090-614 : Practice Test A. CREATE INDEX emp_idx ON employ
显示全部
相似文档