OracleDBA启动和关闭例程试选题
来源:优易学 ?2011-12-29 17:42:56 ? 【优易学:中国教育365bet娱乐_365bet可靠吗_安卓365bet门户网】 ? 资料下载 ? IT书店
q.?1?:?the?database?must?be?in?this?mode?for?the?instance?to?be?started?
  1.?mount?
  2.?open?
  3.?nomount?
  4.?none?
  3?
  q.?2?:?when?oracle?startups?up,?what?happens?if?a?datafile?or?redo?log?file?not?available?or?corrupted?due?to?o.s?problems?
  1.?oracle?returns?a?warning?message?and?opens?the?database?
  2.?oracle?returns?a?warning?message?and?does?not?open?the?database?
  3.?oracle?returns?a?warning?message?and?starts?the?database?recovery?
  4.?oracle?ignores?those?files?and?functions?normally?
  2?
  q.?3?:?the?restricted?session?system?privilege?should?be?given?to?
  1.?users,?who?need?extra?security?while?transfering?the?data?between?client?and?the?server?through?sql*net?or?net8.?
  2.?dbas,?who?perform?structural?maintenance?exports?and?imports?the?data.?
  3.?all?of?the?above?
  4.?none?of?the?above?
  2?
  q.?4?:?when?starting?up?a?database,?if?one?or?more?of?the?files?specified?in?the?control_files?parameter?does?not?exist,?or?cannot?be?opened?
  1.?oracle?returns?a?warning?message?and?does?not?mount?the?database?
  2.?oracle?returns?a?warning?message?and?mounts?the?database?
  3.?oracle?ignores?those?files?and?functions?normally?
  4.?oracle?returns?a?warning?message?and?starts?database?recovery?
  1?
  q.?5?:?bob?tried?to?shutdown?normal,?oracle?said?it?was?unavailable,?and?when?he?tried?to?starup,?oracle?said?that?it?was?already?started.?what?is?the?best?mode?that?bob?can?use?to?force?a?shutdown?on?the?server?
  1.?normal?
  2.?abort?
  3.?immediate?
  4.?none?
  2?
  q.?6?:?tom?issued?a?command?to?startup?the?database.?what?modes?does?the?instance?and?database?pass?through?to?finally?have?the?database?open?
  1.?open,?nomount,?mount?
  2.?nomount,?mount,?open?
  3.?nomount,?open,?mount?
  4.?mount,?open,?nomount?
  2?
  q.?7?:?diane?is?a?new?dba?and?issued?a?shutdown?command?while?her?server?is?being?used.?after?a?while?she?figures?that?oracle?is?waiting?for?all?the?users?to?sign?off.?what?shutdown?mode?did?she?use?
  1.?normal?
  2.?abort?
  3.?immediate?
  4.?none?
  1?
  q.?8?:?which?script?file?creates?commonly?used?data?dictionary?views?
  1.?sql.bsq?
  2.?catalog.sql?
  3.?utlmontr.sql?
  4.?catproc.sql?
  2?
  q.?9?:?in?order?to?perform?a?full?media?recovery,?the?database?must?be?-?
  1.?mounted?and?opened?using?resetlog?option?
  2.?mounted?but?not?opened?
  3.?mounted?and?opened?using?archivelog?option?
  4.?you?cannot?perform?a?full?media?recovery?
  2?
  q.?10?:?when?is?the?parameter?file?read?during?startup?
  1.?when?opening?the?database?
  2.?when?mounting?the?database?
  3.?during?instance?startup?
  4.?in?every?stage?
  3?

责任编辑:小草

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