Please discuss row chaining, how it happens, and how it can be reduced or corrected.

Since this is a two-part question, the best way to respond is to begin by defining the technical term you are being asked about. Once you've done this, you can then describe how to correct the issue associated with the term. Since this is how work is normally done, you should be able to easily structure the response in your mind before presenting it to the interviewer. You can use the acronym CAR to help you remember this. Cause, Affect, Resolution.

"Row chaining is an issue related to the rows in a table within an Oracle database. It occurs when a VARCHAR2 value is updated and the length of the new value is longer than the old value. The row now won't fit in the remaining block space, resulting in the row chaining to another block. By setting the storage parameters on the table to appropriate values, you reduce the chance of this occurring. Doing this after the fact will also correct the issue. It can also be corrected by exporting and importing the affected table."