Oracle
1Z0-054 · Question #107
Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.
The correct answer is D. because retrieving these rows requires more than one data block to be accessed. See the full explanation below for the reasoning.
Question
Identify the reason why chained or migrated rows in a table cause performance degradation when you access them.
Options
- Abecause the ROWID changes for these rows
- Bbecause these rows make existing indexes invalid
- Cbecause it is not possible to use indexes to retrieve these rows
- Dbecause retrieving these rows requires more than one data block to be accessed
- Ebecause the rows force queries to use temporary segments while retrieving them
How the community answered
(28 responses)- B11% (3)
- C7% (2)
- D79% (22)
- E4% (1)
Community Discussion
No community discussion yet for this question.