Oracle
1Z0-417 · Question #44
For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?
The correct answer is A. to determine if objects have unused space that can be released C. to review space usage of individual schema objects or tablespaces. See the full explanation below for the reasoning.
Question
For which two capabilities would you implement Segment Advisor in order to aid a customer trying to find and fix performance issues related to database space?
Options
- Ato determine if objects have unused space that can be released
- Bto advise if materialized views can be used to reduce size of views
- Cto review space usage of individual schema objects or tablespaces
- Dto advise if there are any duplicate indexes and automate their removal
- Eto identify any fragmentation in the database cache or swap space
How the community answered
(25 responses)- A76% (19)
- B4% (1)
- D12% (3)
- E8% (2)
Community Discussion
No community discussion yet for this question.