《IBM DB2 101 Advanced DBA for Linux UNIX and Windows C2090-614题库》.pdf
文本预览下载声明
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
显示全部