Upgrade Oracle DBA 11g to Oracle Database 12c — Question 11

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

Correct answer: A, B

Explanation

The correct answer is A and B because A correctly describes the action of moving segments based on the tbs percent used threshold, and B specifies a follow-up action of setting the target tablespace to read-only. Options C, D, and E do not accurately align with the criteria for automated actions based on the tbs percent used and free parameters.