nerdexam
Oracle

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.

New Features for Storage

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)
  • A
    8% (5)
  • B
    3% (2)
  • C
    74% (46)
  • D
    15% (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.

AMultiple ILM policies may exist for the same segment and any compression levels may be

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.

BSegment-level policies override row-level policies.

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.

CMultiple ILM policies may exist for the same table, if the action is compression and the scope is atCorrect

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.

DMultiple ILM policies may exist for the same segment but greater compression levels must be

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.

EILM policy functions return a Boolean value.Correct

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

#ILM#compression policies#segment-level policies#row-level policies

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice