NIELIT 2021 Dec Scientist B - Section B: 65

Question

Assume that a $\text{DBA}$ issued the following create table command : 

create table $\text{A (Aid, $\dots\dots$)}$

storage $\text{ (initial 20480, next 20480, maxextents 8, minextents 3, pctincrease 0)};$

How many bytes of disk space will be allocated to this file when it is first created $?$

• A. $163,840 \; \text{bytes}$
• B. $20480 \; \text{bytes}$
• C. $61,440 \; \text{bytes}$
• D. $8 \; \text{bytes}$

Answer 1

Option C is correct.

Initial is given as 20480 B, and minextents is given as 3,

So we have to allocate 3 extents (minextents is 3) intially to this file, 

here first extent is 20480 B (because it is initial extent) and others two are Next extent (its size is also 20480 B, because no PCTincrease), PCTincrease is 0 (means percent of increase in next extent, here, no increase)

20480(initial) + 20480*2(Next extent) = 20480*3=61440Bytes

​​​​

Comments

Can you please share some resource to solve such kind of questions ?