1Z0-060 · Question #186
Which two statements are true concerning Information Lifecycle Management (ILM) policies?
The correct answer is C. Multiple ILM policies may exist for the same table, if the action is compression and the scope is at E. ILM policy functions return a Boolean value. ILM policy evaluation functions return a Boolean value, and multiple compression policies may coexist on a single table when scoped at the row level.
Question
Which two statements are true concerning Information Lifecycle Management (ILM) policies?
Options
- AMultiple ILM policies may exist for the same segment and any compression levels may be
- BSegment-level policies override row-level policies.
- CMultiple ILM policies may exist for the same table, if the action is compression and the scope is at
- DMultiple ILM policies may exist for the same segment but greater compression levels must be
- EILM policy functions return a Boolean value.
How the community answered
(62 responses)- A8% (5)
- B3% (2)
- C74% (46)
- D15% (9)
Why each option
ILM policy evaluation functions return a Boolean value, and multiple compression policies may coexist on a single table when scoped at the row level.
Multiple ILM policies on the same segment are subject to constraints based on action type and scope; not every combination of compression levels is permitted simultaneously.
Segment-level policies do not override row-level policies; row-level policy outcomes are evaluated per row and are independent of segment-level policy decisions.
Oracle permits multiple ILM compression policies on the same table provided their scope is at the row level, because row-level policy functions evaluate each row independently and different rows can qualify for different compression actions.
There is no Oracle ILM rule requiring that additional policies on the same segment must use strictly greater compression levels; the actual constraint involves scope and action-type compatibility.
Custom ILM policy evaluation functions used to define job conditions must return a Boolean (TRUE or FALSE) value, which Oracle's Automatic Data Optimization engine uses to determine whether the policy action should be applied.
Concept tested: Oracle ILM ADO policy rules and custom function behavior
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/ilm-strategy-using-ado-and-heat-map.html
Topics
Community Discussion
No community discussion yet for this question.