Oracle DBA 创建数据库试题选

 Q. 1 : This symbol, When you put infront of a line in the parameter file, signifies a comment
　　2. @
　　4. !
　　3
　　Q. 2 : When you change a parameter value in the parameter file, when will that change takes affect?
　　2. At the first CHECKPOINT after saving the paramter file
　　4. At the next instance startup
　　4
　　Q. 3 : ALTER SYSTEM DEFFERED command modifies the global parameters for
　　1. existing sessions after a certain amount of time
　　3. existing and new sessions


Q. 4 : The location where debugging trace files for back ground processes are written, is specified by
　　1. LOGFILE_DEST
　　3. BACKGROUND_DUMP_DEST


　Q. 5 : In case of heavy contention for latches,set the LOG_SIMULTANEOUS_COPIES initialization parameter to
　　2. Same as the DB Block Buffers
　　4. None of the above
　　4
　　Q. 6 : What is the first step in manually creating a new database
　　2. Start SQL*Plus and connect to Oracle as SYSDBA
　　4. Create a parameter file
　　4
　　Q. 7 : Which of the following is true regarding control files
　　2. Oracle recommeds atleast two control files stored on one disk
　　4. One control file is not enough to run a database
　　1
　　Q. 8 : Tom created a database with a DB_BLOCK_SIZE of 2k, he wants to increase this to 4k, what is his next step
　　1. Issue ALTER SYSTEM SET DB_BLOCK_SIZE=4k command 　　2. recreate the database with the new setting
　　4. the DB_BLOCK_SIZE cannot be 4k
　　2
　　Q. 9 : Howmany rollback segments are required for Oracle to startup apart from SYSTEM rollback segment
　　1. Oracle can start with just the system rollback segment
　　3. Oracle Needs a Temp Rollback Segment before it can start


Q. 10 : The unit of measurement for DB_BLOCK_SIZE intialization parameter is
　　2. BYTE
　　4. ROW
　　2
　　Q. 11 : This tablespace is a must before you run the database instance
　　1. ROLLBACK
　　3. TEMP


Q. 12 : Which initialization parameter determines the rollback segments that can be used by Oracle
　　1. ROLLBACKS
　　3. ROLLBACK_SEGMENTS


Q. 13 : Which of the following is a valid but undocumented parameter in Oracle
　　1. _CORRUPT_RBS
　　3. _CORRUPT_ROLLBACK_SEGMENTS