Multiple choice

Examine the syntax for creating a DEPARTMENT table: CREATE TABLE department( Deptno NUMBER(4), Dname VARCNAR2(30), mgr NUMBER(6), Loc NUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) TABLESPACE userdata; What is the size defined for the fifth extent?

  1. 200 K

  2. 300 K

  3. 450 K

  4. 675 K
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

With PCTINCREASE 50, each extent grows by 50% over the previous extent. Extent 1: 200K (INITIAL). Extent 2: 200K (NEXT). Extent 3: 200K + 100K (50% of 200K) = 300K. Extent 4: 300K + 150K (50% of 300K) = 450K. Extent 5: 450K + 225K (50% of 450K) = 675K. Option D correctly calculates the fifth extent size using the PCTINCREASE formula.

Keep practicing — related questions