Oracle Global Human Resources Cloud 2016 Implementation Specialist — Question 4

Which are two strategies to maintain performance and improve a table segment's compression ratio when you are using Advanced Row Compression on a table segment?

Answer options

• A. Use smaller database block size.
• B. Use larger database block size.
• C. Use direct-path inserts where possible.
• D. Increase PCTFREE on the table segment.
• E. Increase the size of the tablespace.

Correct answer: A, E

Explanation

Using a smaller database block size can improve compression by allowing more efficient storage of data, while increasing the size of the tablespace provides additional room for data. On the other hand, larger block sizes, direct-path inserts, and adjusting PCTFREE do not directly enhance compression ratios in the same way.