Oracle

1Z0-054 · Question #108

View the Exhibit and analyze the output of the query. What does the high value for the table fetch continued rows statistics indicate?

The correct answer is D. both chained and migrated rows fetched. See the full explanation below for the reasoning.

Question

View the Exhibit and analyze the output of the query. What does the high value for the table fetch continued rows statistics indicate?

Exhibit

1Z0-054 question #108 exhibit

Options

Achained rows fetched only
Bmigrated rows fetched only
Crows fetched from external tables
Dboth chained and migrated rows fetched
Erows fetched from Index Organized Tables (IOT)

How the community answered

(42 responses)

A
17% (7)
B
7% (3)
C
2% (1)
D
71% (30)
E
2% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-054 Practice