c. row chaining
Row chaining occurs when a VARCHAR2 value is updated and the length of the new value is longer than the old value and won't fit in the remaining block space. This results in the row chaining to another block. It can be reduced by setting the storage parameters on the table to appropriate values. It can be corrected by export and import of the effected table.
For More Information
Expert response: 26 must-know performance tuning solutions
Expert response: Why can't size of primary key exceed one database block?
Do you have an idea for a quiz question topic? Let us know!