PrepAway - Latest Free Exam Questions & Answers

Which of the following commands should be used to resol…

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

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply