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)- B5% (1)
- C5% (1)
- D82% (18)
- E9% (2)
Explanation
Explanation/Reference:
Topics
#ILM#Heat Map#segment statistics#HEAT_MAP parameter
Community Discussion
No community discussion yet for this question.