Oracle
1Z0-417 · Question #52
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?
The correct answer is A. Use smaller database block size. E. Increase the size of the tablespace. See the full explanation below for the reasoning.
Question
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?
Options
- AUse smaller database block size.
- BUse larger database block size.
- CUse direct-path inserts where possible.
- DIncrease PCTFREE on the table segment.
- EIncrease the size of the tablespace.
How the community answered
(50 responses)- A74% (37)
- B4% (2)
- C16% (8)
- D6% (3)
Community Discussion
No community discussion yet for this question.