OracleDBA存储管理试题选
来源:优易学 ?2011-12-29 17:50:37 ? 【优易学:中国教育365bet娱乐_365bet可靠吗_安卓365bet门户网】 ? 资料下载 ? IT书店
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?
  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?update?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?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

责任编辑:小草

文章搜索:
?相关文章
热点资讯
热门课程培训