Upgrade to Oracle Database 12c — Question 28

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

Answer options

• A. Tracking the most recent read time for a table segment in a user tablespace
• B. Tracking the most recent write time for a table segment in a user tablespace
• C. Tracking insert time by row for table rows
• D. Tracking the most recent write time for a table block in a table segment
• E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Correct answer: A, B, C

Explanation

The correct answers A, B, and C are tasks that Automatic Data Optimization can perform, focusing on tracking read and write times for table segments and rows. Options D, E, and F are incorrect because they either refer to block-level operations or pertain to a different tablespace that is not primarily managed by ILM in this context.