Oracle
1Z0-054 · Question #127
Which two statements are valid regarding row migration? (Choose two.)
The correct answer is B. The row migration causes more than one block to be read when a row is accessed. E. It is caused by an UPDATE statement that increases the data in a row so that the new larger. See the full explanation below for the reasoning.
Question
Which two statements are valid regarding row migration? (Choose two.)
Options
- AIt can be reduced by decreasing the PCTFREE value.
- BThe row migration causes more than one block to be read when a row is accessed.
- CIt can be resolved by using the ANALYZE TABLE...ESTIMATE STATISTICS command.
- DIt is caused by inserting a row into an empty data block where the row is too large to fit into that
- EIt is caused by an UPDATE statement that increases the data in a row so that the new larger
How the community answered
(27 responses)- A4% (1)
- B78% (21)
- C11% (3)
- D7% (2)
Community Discussion
No community discussion yet for this question.