nerdexam
Oracle

1Z0-060 · Question #127

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle…

The correct answer is B. Setting the target tablespace to read-only C. The movement of some segments to a target tablespace with a higher degree of compression, on a. The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of…

New Features for Storage

Question

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

Options

  • AThe movement of all segments to a target tablespace with a higher degree of compression,on a different
  • BSetting the target tablespace to read-only
  • CThe movement of some segments to a target tablespace with a higher degree of compression, on a
  • DSetting the target tablespace offline
  • EThe movement of some blocks to a target tablespace with a lower degree of compression, on a different

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    60% (12)
  • D
    10% (2)
  • E
    25% (5)

Explanation

The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.

Topics

#ILM storage tiering#TBS_PERCENT_USED#compression#data movement

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice