nerdexam
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

1Z0-043 question #165 exhibit

Options

  • ASegment Advisor
  • BSQL Access Advisor
  • CSQL Tuning Advisor
  • DMemory Advisor
  • EAutomatic Database Diagnostic Monitor (ADDM)

How the community answered

(26 responses)
  • A
    69% (18)
  • B
    8% (2)
  • C
    4% (1)
  • D
    4% (1)
  • E
    15% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice