Oracle DBA创建数据库试题选.docVIP

Oracle DBA创建数据库试题选 Q.?1?:?This?symbol,?When?you?put?infront?of?a?line?in?the?parameter?file,?signifies?a?comment? 　　1.?$? 　　2.?@? 　　3.?#? 　　4.?!? 　　3? 　　Q.?2?:?When?you?change?a?parameter?value?in?the?parameter?file,?when?will?that?change?takes?affect?? 　　1.?Immediately?after?saving?the?parameter?file? 　　2.?At?the?first?CHECKPOINT?after?saving?the?paramter?file? 　　3.?When?the?DBWR?finishes?writing?all?the?dirty?buffers?to?the?disk? 　　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? 　　2.?new?sessions?only? 　　3.?existing?and?new?sessions? 　　4.?depends?on?the?SPIN_COUNT?initialization?parameter? 　　2? 　　Q.?4?:?The?location?where?debugging?trace?files?for?back?ground?processes?are?written,?is?specified?by? 　　1.?LOGFILE_DEST? 　　2.?ORACLE_HOME? 　　3.?BACKGROUND_DUMP_DEST? 　　4.?CORE_DUMP_DEST? 　　3? 　　Q.?5?:?In?case?of?heavy?contention?for?latches,set?the?LOG_SIMULTANEOUS_COPIES?initialization?parameter?to? 　　1.?Twice?the?number?of?CPUs? 　　2.?Same?as?the?DB?Block?Buffers? 　　3.?Same?as?the?Shared?Pool?Size? 　　4.?None?of?the?above? 　　4? 　　Q.?6?:?What?is?the?first?step?in?manually?creating?a?new?database? 　　1.?Startup?an?instance? 　　2.?Start?SQL*Plus?and?connect?to?Oracle as?SYSDBA? 　　3.?Check?the?instance?identifier?for?your?system? 　　4.?Create?a?parameter?file? 　　4? 　　Q.?7?:?Which?of?the?following?is?true?regarding?control?files? 　　1.?Oracle?recommeds?atleast?two?control?files?stored?on?two?separate?disks? 　　2.?Oracle?recommeds?atleast?two?control?files?stored?on?one?disk? 　　3.?Oracle?recommeds?to?store?one?control?file? 　　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? 　　3.?It?can?be?done?in