nerdexam
Oracle

1Z0-074 · Question #16

You plan to use Information Lifecycle Management (ILM) for the ORDERS table. Which is true about Heat Map statistics when HEAT_MAP is ON?

The correct answer is D. They are collected for all segments and are stored in the SYSTEM tablespace. Explanation/Reference:

Using Advanced SQL Features

Question

You plan to use Information Lifecycle Management (ILM) for the ORDERS table. Which is true about Heat Map statistics when HEAT_MAP is ON?

Options

  • AThey are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and
  • BThey are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and
  • CThey are collected for all segments and are stored in the SYSAUX tablespace.
  • DThey are collected for all segments and are stored in the SYSTEM tablespace.
  • EThey are collected only for the ORDERS table if it has an associated ADO policy.

How the community answered

(22 responses)
  • B
    5% (1)
  • C
    5% (1)
  • D
    82% (18)
  • E
    9% (2)

Explanation

Explanation/Reference:

Topics

#ILM#Heat Map#segment statistics#HEAT_MAP parameter

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice