Multiple choice

The storage parmeters for a given table are: INITIAL=100, NEXT=100, MINEXTENTS=2, MAXEXTENTS=10, PCTINCREASE=20. If the first 3 extents are filled, what will be the size of the FOURTH extent?

  1. 120

  2. 140

  3. 144

  4. 240

  5. 400

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

With PCTINCREASE=20, each subsequent extent grows by 20%. Extent 1: 100, Extent 2: 100. Extent 3: 100*1.2=120. Extent 4: 120*1.2=144. The percentage applies to the previous extent's size.

Keep practicing — related questions