Multiple choice technology databases

Which script creates the CHAINED_ROWS table

  1. catproc.sql

  2. utlchain.sql

  3. catchain.sql

  4. utlproc.sql

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle databases, the utlchain.sql script creates the CHAINED_ROWS table, which stores information about chained and migrated rows. This table is used with the ANALYZE command to identify rows that are chained or migrated across multiple blocks, helping optimize database performance.