Oracle Database 12c: Advanced Administration — Question 157

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

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 each block in a table segment
• E. tracking the most recent read time for a table segment in the sysauxtablespace
• F. tracking the most recent write time for a table segment in the sysauxtablespace

Correct answer: A, B, D

Explanation

The correct answers A, B, and D are functionalities that the Automatic Data Optimization feature can perform, which include tracking read and write times for table segments and blocks. Options C, E, and F do not represent tasks that ILM's Automatic Data Optimization handles in this context, as they either refer to specific types of tracking that are not part of its capabilities or involve the sysauxtablespace, which is not applicable here.