Oracle Database 12c: Advanced Administration — Question 160

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

Answer options

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
• B. Setting the target tablespace to read-only after the segments are moved
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
• D. Taking the target tablespace offline after the segments are moved
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Correct answer: B, C

Explanation

The correct answers, B and C, involve actions that can be automated through ILM when the tbs percent used threshold is exceeded. Option B is correct as it involves making the target tablespace read-only after data movement, which is a common practice to prevent changes. Option C, however, contains a typographical error ('T3S percent used') and does not reflect the correct parameter, making it less applicable compared to the other options.