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!
Dig Deeper on Oracle DBA jobs, training and certification
Solve a PL-SQL error that creates dynamic tables
In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 4
IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 3