Oracle
1Z0-043 · Question #165
View the Exhibit and examine the characteristics of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you…
The correct answer is A. Segment Advisor. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the characteristics of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to, in order to find information about table fragmentation?
Exhibit
Options
- ASegment Advisor
- BSQL Access Advisor
- CSQL Tuning Advisor
- DMemory Advisor
- EAutomatic Database Diagnostic Monitor (ADDM)
How the community answered
(26 responses)- A69% (18)
- B8% (2)
- C4% (1)
- D4% (1)
- E15% (4)
Community Discussion
No community discussion yet for this question.
