Oracle DBA 存储管理试题选

 Q. 1 : Oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows.
　　 　　1. True
　　
　　　
Q. 2 : Which of the following three portions of a data block are collectively called as Overhead.
　　 　　1. table directory, row directory and row data
　　3. table directory, row directory and data blcok header
　　
　　
Q. 3 : Which portion of the data block contains table or index data 　　
　　2. row directory
　　4. row data
　　4 　　
　　Q. 4 : What are the two space management parameters for controling the use of free space in a data block
　　 　　1. INITIAL and NEXT
　　3. TABLESPACE and STORAGE
　　
　　　　
Q. 5 : The maximum number of transactions that a block can support is
　　 　　1. 100
　　3. 1000
　　　
　　　
Q. 6 : what is PCTFREE
　　 　　1. A space management parameter which sets aside that much percentage of memory in the data block for future update of existing rows.
　　3. A space management parameter which tells Oracle that the block is available for inserts after the percentage of used memory falls below certain percentage.
　　　
　　
Q. 7 : What is the default value of NEXT parameter
　　 　　1. 1 block
　　3. 5 blocks
　　
　　
Q. 8 : Which parameter reserves the more space for future updates
　　 　　1. high PCTINCREASE
　　3. high INITIAL
　　　
　　
Q. 9 : PCTFREE and PCTUSED together should not exceed
　　 　　1. 100
　　3. 25
　　
　　
Q. 10 : Row migration is a result of
　　 　　1. not enough space in a block for new rows.
　　3. not enough space for updates in the current block
　　
　　　
Q. 11 : Frequent deallocation of extents result in
　　 　　1. truncated segments
　　3. truncated tablespaces
　　
　　
　Q. 13 : Row migration is a result of
　　 　　1. high PCTFREE
　　3. high PCTUSED
　　　
　　
　Q. 12 : Which background process coalesce the fragmented space
　　
　　2. PMON
　　4. LGWR
　　1