IBM
C2090-312 · Question #62
C2090-312 Question #62: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-312 to reveal the answer and full explanation for question #62. The question stem and answer options stay visible for context.
Question
Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?
Options
- ACopy the index.
- BREBUILD the index.
- CCompress the tablespace.
- DALTER the index to use a page size larger than 4K.
Unlock C2090-312 to see the answer
You've previewed enough free C2090-312 questions. Unlock C2090-312 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.