熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle DBA創建數據庫試題精選

2013-11-13 16:04:51  來源: Oracle 

  Q : This symbol When you put infront of a line in the parameter file signifies a comment
  
   $
   @
   #
   !
  
  
  
  
  
  Q : When you change a parameter value in the parameter file when will that change takes affect?
  
   Immediately after saving the parameter file
   At the first CHECKPOINT after saving the paramter file
   When the DBWR finishes writing all the dirty buffers to the disk
   At the next instance startup
  
  
  
  
  
  Q : ALTER SYSTEM DEFFERED command modifies the global parameters for
  
   existing sessions after a certain amount of time
   new sessions only
   existing and new sessions
   depends on the SPIN_COUNT initialization parameter
  
  
  
  
  Q : The location where debugging trace files for back ground processes are written is specified by
  
   LOGFILE_DEST
   ORACLE_HOME
   BACKGROUND_DUMP_DEST
   CORE_DUMP_DEST
  
  
  
  
  
  Q : In case of heavy contention for latches set the LOG_SIMULTANEOUS_COPIES initialization parameter to
  
   Twice the number of CPUs
   Same as the DB Block Buffers
   Same as the Shared Pool Size
   None of the above
  
  
  
  
  
  Q : What is the first step in manually creating a new database
  
   Startup an instance
   Start SQL*Plus and connect to Oracle as SYSDBA
   Check the instance identifier for your system
   Create a parameter file
  
  
  
  
  Q : Which of the following is true regarding control files
  
   Oracle recommeds atleast two control files stored on two separate disks
   Oracle recommeds atleast two control files stored on one disk
   Oracle recommeds to store one control file
   One control file is not enough to run a database
  
  Q : Tom created a database with a DB_BLOCK_SIZE of k he wants to increase this to k what is his next step
  
   Issue ALTER SYSTEM SET DB_BLOCK_SIZE=k command
   recreate the database with the new setting
   It can be done in both the ways
   the DB_BLOCK_SIZE cannot be k
  
  
  
  
  
  Q : Howmany rollback segments are required for Oracle to startup apart from SYSTEM rollback segment
  
   Oracle can start with just the system rollback segment
   Oracle Needs atleast rollback segments before it can start
   Oracle Needs a Temp Rollback Segment before it can start
   None of the above
  
  
  
  
  
  Q : The unit of measurement for DB_BLOCK_SIZE intialization parameter is
  
   BLOCKS
   BYTE
   PAGE
   ROW
  
  
  
  
  Q : This tablespace is a must before you run the database instance
  
   ROLLBACK
   TOOLS
   TEMP
   SYSTEM
  
  
  
  
  
  Q : Which initialization parameter determines the rollback segments that can be used by Oracle
  
   ROLLBACKS
   LOGFILE GROUP
   ROLLBACK_SEGMENTS
   DBA_ROLLBACK_SEGS
  
  
  
  
  
  Q : Which of the following is a valid but undocumented parameter in Oracle
  
   _CORRUPT_RBS
   _CORRUPT_REDO
   _CORRUPT_ROLLBACK_SEGMENTS
   None of the above
  

From:http://tw.wingwit.com/Article/program/Oracle/201311/17773.html
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.