OracleDBA启动和关闭例程试题选Oracle认证考试

文章作者 100test 发表时间 2009:07:07 20:05:21
来源 100Test.Com百考试题网


  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



相关文章


OracleDBA用户管理试题选Oracle认证考试
OracleDBA审计数据库试题选Oracle认证考试
OracleDBA数据库结构试题选2Oracle认证考试
OracleDBA数据库结构试题选1Oracle认证考试
OracleDBA启动和关闭例程试题选Oracle认证考试
ORACLE认证相关问题与解答2Oracle认证考试
ORACLE认证相关问题与解答1Oracle认证考试
国外某公司的OracleDBA试题Oracle认证考试
OracleDBA面试题及参考答案Oracle认证考试
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛