IBM
C2090-600 · Question #30
C2090-600 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-600 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Question
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table. Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
Options
- AREORG TABLE sales INPLACE RESETDICTIONARY
- BREORG TABLE sales INPLACE REBUILDDICTIONARY
- CREORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
- DREORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
Unlock C2090-600 to see the answer
You've previewed enough free C2090-600 questions. Unlock C2090-600 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.