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
