Which three tasks can be automatically performed by the Automatic Data Optimization feature of
Information lifecycle Management (ILM)?
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
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
Explanation:
* You can specify policies for ADO at the row, segment, and tablespace level when creating and
altering tables with SQL statements.
* (Not E, Not F) When Heat Map is enabled, all accesses are tracked by the in-memory activity
tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access
and modification.
Heat Map provides data access tracking at the segment-level and data modification tracking at the
segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access
and modification. You can also use Automatic Data Optimization (ADO) to automate the
compression and movement of data between different tiers of storage within the database.
Reference: Automatic Data Optimization with Oracle Database 12c
with Oracle Database 12c
ABD is right
In Oracle Database 11g, the lowest level to determine data classes is the segment, table, or partition.
In Oracle Database 12c, you can classify each row of a table based on its operational
relevance by using the new row-level data classification.
The answer should be A,B,C
ABD
ABD for sure
Not sure C wrong now
ABC –
ADO policies tracks both access and modification at Segment level and modification only at Row level.
Correct answers ABD
AB: https://docs.oracle.com/cloud/latest/db121/VLDBG/part_lifecycle.htm#VLDBG14124
excerp: “When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.”
D: http://www.oracle.com/technetwork/issue-archive/2015/15-jan/o15ocp-2398998.html
Correction:
Correct answers: ABD
EF: wrong (https://docs.oracle.com/cloud/latest/db121/VLDBG/part_lifecycle.htm#VLDBG14124
excerp: When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.)
D: correct (http://www.oracle.com/technetwork/issue-archive/2015/15-jan/o15ocp-2398998.html)
ADO policies can be specified at the segment or row level for tables and table partitions. Policies will be evaluated and executed automatically in the background during the maintenance window.
http://www.oracle.com/technetwork/database/automatic-data-optimization-wp-12c-1896120.pdf
Row level and segment level.
ABC
ABD, I think C is incorrect because it refers to “insert time” and not to most recent write time..
Heat Map is a new feature in Oracle Database 12c that automatically tracks usage information at the row and segment levels.
Data modification times are tracked at the row level and aggregated to the block level, and modification times, full table scan times, and index lookup times are tracked at the segment level.
C is not correct as it’s mentioning insert time rather modification time.
http://www.oracle.com/technetwork/database/automatic-data-optimization-wp-12c-1896120.pdf
Heat Map, a feature in Oracle Advanced Compression, automatically tracks table/partition usage information at the row and segment levels. Data modification times are tracked at the row level and aggregated to the block
level, and modification times, full table scan times, and index lookup times are tracked at the segment level.
So the correct answer is ABD.
ABD