OracleDBA存储管理试题选

文章作者 100test 发表时间 2007:03:14 13:26:35
来源 100Test.Com百考试题网


q. 1 : oracle immediately re-uses the space assigned to row-directory portion of the data block once you 0delete the corresponding rows.
  
  1. true
  2. false  
  
  2
   
  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
  2. data block header, table diretory and free space
  3. table directory, row directory and data blcok header
  4. data block header, row data and row header  
  
  3  
  
  q. 3 : which portion of the data block contains table or index data
  
  1. table directory
  2. row directory
  3. overhead
  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
  2. pctfree and pctused
  3. tablespace and storage
  4. free space cannot be controlled at block level  
  
  2
    
  q. 5 : the maximum number of transactions that a block can support is
  
  1. 100
  2. 255
  3. 1000
  4. unlimited
   
  2
   
  q. 6 : what is pctfree
  
  1. a space management parameter which sets aside that much percentage of memory in the data block for future 0update of existing rows.
  2. a space management parameter which determines the minimum percentage of a block that can be used for row data plus overhead.
  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.
  4. all of them
   
  1   
  
  q. 7 : what is the default value of next parameter
  
  1. 1 block
  2. 2 blocks
  3. 5 blocks
  4. 100 blocks  
  
  3  
  
  q. 8 : which parameter reserves the more space for future 0updates
  
  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


相关文章


OracleDBA创建数据库试题选
报考指南:Oracle认证一览(下)
Oracle9IOCP认证过程
OracleDBA存储管理试题选
报考指南:Oracle认证一览(上)
OracleDBA回滚段管理试题选
OracleDBA用户管理试题选
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛