Examine the syntax for creating a DEPARTMENT table: CREATE TABLE ABCD( A NUMBER(4), B VARCNAR2(30), C NUMBER(6), D NUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) TABLESPACE userdata; What is the size defined for the fifth extent?
C
Correct answer
Explanation
The STORAGE clause calculates extent sizes using PCTINCREASE. First extent = INITIAL = 200K. Second extent = NEXT = 200K. Third extent = NEXT * (1 + PCTINCREASE/100) = 200K * 1.5 = 300K. Fourth extent = 300K * 1.5 = 450K. Fifth extent = 450K * 1.5 = 675K. PCTINCREASE of 50 means each extent grows by 50% from the previous one. Option C correctly calculates 675K for the fifth extent.