Multiple choice

What is the purpose of the INCLUDING clause in the CREATE TABLE syntax for an Index Organized Table?

  1. It specifies at which column to break a row into two pieces when a row's length exceeds the size set aside in PCTTHRESHOLD.

  2. It specifies the name of the primary key column in the index organized table.

  3. It specifies what percentage of the entire data block to hold open in order to store the row data associated with a primary key value.

  4. It specifies the tablespace where the second half of the row data will be stored when the row's length exceeds the size set aside in PCTTHRESHOLD.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Index Organized Tables (IOTs), the INCLUDING clause specifies which column should be the last column stored in the index segment when a row exceeds PCTTHRESHOLD. Columns after the INCLUDING column are stored in the overflow segment. This controls how rows are split between the index and overflow areas.

Keep practicing — related questions