Q. 8 : Which parameter reserves the more space for future updates
1. high PCTINCREASE
2. high PCTFREE
3. high INITIAL
4. high PCTUSED
2
Q. 9 : PCTFREE and PCTUSED together should not exceed
1. 100
2. 50
3. 25
4. 10
1
Q. 10 : Row migration is a result of
1. not enough space in a block for new rows.
2. not enough memory for sorts
3. not enough space for updates in the current block
4. all of them
3
Q. 11 : Frequent deallocation of extents result in
1. truncated segments
2. block fragmentation
3. truncated tablespaces
4. tablespace fragmentation
4
Q. 13 : Row migration is a result of
1. high PCTFREE
2. low PCTFREE
3. high PCTUSED