Exam4Training

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.

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
A . REORG TABLE sales INPLACE RESETDICTIONARY
B . REORG TABLE sales INPLACE REBUILDDICTIONARY
C . REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
D . REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Answer: C

Latest C2090-600 Dumps Valid Version with 60 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version