OracleDBA数据库结构试题精选
来源:优易学 ?2011-12-29 17:47:04 ? 【优易学:中国教育365bet娱乐_365bet可靠吗_安卓365bet门户网】 ? 资料下载 ? IT书店
q.?1?:?physical?disk?resources?in?an?oracle?database?are?
  1.?control?files?
  2.?redo?log?files?
  3.?data?files?
  4.?all?of?the?above?
  4?
  q.?2?:?what?is?a?schema?
  1.?a?physical?organization?of?objects?in?the?database?
  2.?a?logical?organization?of?objects?in?the?database?
  3.?a?scheme?of?indexing?
  4.?none?of?the?above?
  2?
  q.?3?:?an?oracle?instance?is?
  1.?oracle?memory?structures?
  2.?oracle?i/o?structures?
  3.?oracle?background?processes?
  4.?all?of?the?above?
  4?
  q.?4?:?the?sga?consists?of?the?following?items?
  1.?buffer?cache?
  2.?shared?pool?
  3.?redo?log?buffer?
  4.?all?of?the?above?
  4?
  q.?5?:?the?area?that?stores?the?blocks?recently?used?by?sql?statements?is?
  1.?shared?pool?
  2.?buffer?cache?
  3.?pga?
  4.?uga?
  2?
  q.?6?:?which?of?the?following?is?not?a?background?server?process?in?an?oracle?
  1.?db?writer?
  2.?db?reader?
  3.?log?writer?
  4.?smon?
  2?
  q.?7?:?which?of?the?following?is?a?valid?background?server?processes?in?oracle
  1.?archiver?
  2.?lgwr?(?log?writer?)?
  3.?dbwr?(?dbwriter?)?
  4.?all?of?the?above?
  4?
  q.?8?:?the?process?that?writes?the?modified?blocks?to?the?data?files?is?
  1.?dbwr?
  2.?lgwr?
  3.?pmon?
  4.?smon?
  1?:?oracle?does?not?modify?the?data?in?data?file.?once?the?server?process?
makes?a?change?in?the?memory,?dbwr?writes?the?modified?blocks?back?to?disk.?
  q.?9?:?the?process?that?records?information?about?the?changes?made?by?all?
  1.?dbwr?
  2.?smon?
  3.?ckpt?
  4.?none?of?the?above?
  4?:?lgwr?process?records?the?information?about?changes?to?database?
  q.?10?:?oracle?does?not?consider?a?transaction?committed?until?
  1.?the?data?is?written?back?to?the?disk?by?dbwr?

  2.?the?lgwr?successfully?writes?the?changes?to?redo?
  3.?pmon?process?commits?the?process?changes?
  4.?smon?process?writes?the?data?
  q.?11?:?the?process?that?performs?internal?operations?like?tablespace?

责任编辑:小草

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