Oracle 10g OCP 042 题库 31-70 题 共168题
31.WhichtwostatementsaretrueregardingthedatabaseinARCHIVELOGmode?(Choosetwo.)
A)Youhavetoshutdownthedatabasetoperformthebackups.
B)Archivinginformationiswrittentothedatafilesandredologfiles.
C)Youcanperformcompletedatabasebackupswithoutclosingthedatabase.
D)OnlineredologfileshavetobemultiplexedbeforeputtingthedatabaseinARCHIVELOGmode.
E)AllthepreviousdatabasebackupsbecomeinvalidafteryouconfigurethedatabasetoARCHIVELOGmode.
答案：CE.
32.Youperformdifferentialincrementallevel1backupsofyourdatabaseoneachworkingdayandlevel0
backuponSundays.Whichtwostatementsaretrueaboutthedifferentialincrementalbackups?(Choosetwo.)
A)ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenuseinthedatabase.
B)ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.
C)Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0orlevel
1backup.
D)Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0backup.
答案：AC
33.YourequiretheOracleservertomanagetheundosegmentsandspaceamongvariousactivesessions
automatically.Youcreatedanundotablespace,UNDO_TBS1,inyourdatabase.Whichtwoadditionalsteps
wouldyouperformtoachievethis?(Choosetwo.)
A)SettheUNDO_RETENTIONparameterto900ormore.
B)Createaninitialundosegmentintheundotablespace.
C)Enabletheretentionguaranteefortheundotablespace.
D)SettheUNDO_TABLESPACEparametertoUNDO_TBS1.
E)SettheUNDO_MANAGEMENTinitializationparametertoAUTO.
答案：DE
Oracleundo管理
http://blog.****.net/tianlesoftware/archive/2009/11/30/4901666.aspx
Oracleundo表空间管理
http://blog.****.net/tianlesoftware/archive/2010/07/11/5689558.aspx
34.WhichtwostatementsaretrueregardingaPL/SQLpackagebody?(Choosetwo.)
A)Itcannotbecreatedwithoutapackagespecification.
B)Itcannotinvokesubprogramsdefinedinotherpackages.
C)Itcancontainonlythesubprogramsdefinedinthepackagespecification.
D)Itcanbechangedandrecompiledwithoutmakingthepackagespecificationinvalid.
答案：AD
35.UserAexecutesthefollowingcommandtoupdatetheTRANStable)
SQL>UPDATEB.transSETtr_amt=tr_amt+500WHEREc_code='C005';
BeforeuserAissuesaCOMMITorROLLBACKcommand,userBexecutesthefollowingcommandonthe
TRANStable:
SQl>ALTERTABLEtransMODIFY(tr_typeVARCHAR2(3));
Whatwouldhappeninthisscenario?
A)ThetransactionforuserAisrolledback.
B)TheALTERTABLEcommandmodifiesthecolumnsuccessfully.
C)TheALTERTABLEcommandfailsduetotheresourcebeingbusy.
D)TheALTERTABLEcommandwaitsuntiluserAendsthetransaction.
答案：C
36.Whichthreestatementsaretrueregardingthefine-grainedauditing(FGA)?(Choosethree.)
A)FGAispossibleonSELECTstatementsonly.
B)TheaudittrailforFGAisstoredintheFGA_LOG$table.
C)TheaudittrailforFGAisstoredintheAUD_LOG$table.
D)FGAenablesaSQLpredicatetodefinewhentoauditanevent.
E)FGAauditsDELETEstatementsonlywhenauditcolumnsarespecified.
F)FGAincludestheSQLstatementusedbytheuseraspartoftheauditevententry.
答案：BDF
理解的也不是很透彻，参考AboutFine-GrainedAuditing小节：
http://download.oracle.com/docs/cd/E11882_01/network.112/e10574/auditing.htm#DBSEG60681
37.WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAin
iSQL*Plus?
A)Theusermustbegrantedthedatabaseadministrator(DBA)privilege.
B)Theusermustbelistedinthepasswordfilefortheauthentication.
C)NospecialsetupisneededfortheusertoconnectasSYSDBAiniSQL*Plus.
D)SetupauserintheOracleApplicationServerContainersforJ2EE(OC4J)usermanager,andgrantthewebDba
roletotheuser.
答案：D
38.InyourOracle10gdatabase,youhavescheduledajobtoupdatetheoptimizerstatisticsat05)00pm
everyFriday.Thejobhassuccessfullycompleted.Whichthreepiecesofinformationwouldyoucheckto
confirmthatthestatisticshavebeencollected?(Choosethree.)
A)averagerowsize
B)lastanalyzeddate
C)sizeoftableinbytes
D)sizeoftableindatabaseblocks
E)numberoffreeblocksinthefreelist
F)numberofextentspresentinthetable
答案：ABD
http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/stats.htm#PFGRF94712
16.5.1VerifyingOptimizerStatistics
http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/sql_overview.htm#PFGRF94815
39.YourdatabaseisopenandusersareconnectedusingtheLISTENERlistener.ThenewDBAofthesystemstopsthelistenerbyusingthefollowingcommand:
LSNRCTL>STOP
Whatwouldhappentothesessionsthatarepresentlyconnectedtothedatabaseinstance?
A)Thesessionsareabletoperformonlyqueries.
B)Thesessionsarenotaffectedandcontinuetofunctionnormally.
C)Theactivetransactionsarerolledbackandthesessionsgetterminated.
D)Thesessionsarenotallowedtoperformanyoperationstillthelistenerisstarted.
答案：B
40.Afterbeinghiredasadatabaseadministrator,youfindthatthereisonlyonedatabasethatisfunctional
andthatisbeingaccessedbytheapplications.Youwanttocreateareplicaofthedatabase,tobeusedfor
testingpurposes.Whatisthebestmethodtocreatethereplica?
A)createadatabasebyusingCREATEDATABASE..commandandmanuallycopythedata
B)useDatabaseConfigurationAssistant(DBCA)tocreateatemplatefromtheexistingdatabasetocontainthe
databasestructure
C)useDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructureandthenmanually
copythedatausingOracleDataPump
D)useDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructurewithdatafilesandthen
usethesametemplatetocreatethedatabaseinthenewlocation
答案：D
41.Youareworkingonthe24X7databasewithhightransactionvolume,toensurefasterinstancerecoveryonyourdatabaseyousettheFAST_START_MTTR_TARGETinitializationparametertoaverylowvalue.Whateffectitwillhaveonthedatabase?
A)Thedatabaseperformancewouldbeenhanced.
B)Theredologfileswouldbegetfilledmorefrequently.
C)Theoveralldatabaseperformancewouldbedegraded.
D)Themeantimetorecover(MTTR)wouldbeincreased.
答案：C
10.5.3TuningFAST_START_MTTR_TARGETandUsingMTTRAdvisor
http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/instance_tune.htm#PFGRF13015
42.Youareworkingonanonlinetransactionprocessing(OLTP)system.YounoticethataPL/SQLproceduregotexecutedtwiceat2:00p.m.ThishasincorrectlyupdatedtheEMP_SALtable.Howwouldyourevertthetabletoitsstateat2:00p.m.?
A)Performpoint-in-timerecoveryto2:00p.m.
B)UseFlashbackTablefeaturetorevertthechanges.
C)Restoretheentiredatabasefromtherecentbackupandopenit.
D)Issuetherollbackstatementwithsystemchangenumber(SCN).
答案：B
OracleFlashback技术总结
http://blog.****.net/tianlesoftware/archive/2009/10/16/4677378.aspx
43.Accordingtoyourbackupstrategy,youperformedanincrementallevel0backupofyourdatabase.Whichstatementregardingthisbackupistrue?
A)Thebackupissimilartoimagecopy.
B)Thebackupcontainsalluseddatablocks.
C)Thebackupcontainsonlyunuseddatablocks.
D)Thebackupcontainsalldatablockschangedsincethelastincrementallevel1backup.
答案：B
44.UserSCOTTexecutesthefollowingcommandontheEMPtablebuthasnotissuedCOMMIT,ROLLBACK,oranydatadefinitionlanguage(DDL)command:
SQL>SELECTjobFROMempWHEREjob='CLERK'FORUPDATEOFempno;
SCOTThasopenedanothersessiontoworkwiththedatabase.WhichthreeoperationswouldwaitwhenissuedinSCOTT'ssecondsession?(Choosethree.)
A)LOCKTABLEempINSHAREMODE;
B)LOCKTABLEempINEXCLUSIVEMODE;
C)DELETEFROMempWHEREjob='MANAGER';
D)INSERTINTOemp(empno,ename)VALUES(1289,'Dick');
E)SELECTjobFROMempWHEREjob='CLERK'FORUPDATEOFempno;
答案：ABE
update,insert,delete,select...forupdate会LOCK相应的ROW.只有一个TRANSACTION可以LOCK相应的行，也就是说如果一个ROW已经LOCKED了，那就不能被其他TRANSACTION所LOCK了。LOCK由statement产生,由TRANSACTION结尾（commit，rollback），也就是说一个SQL完成后LOCK还会存在，只有在COMMIT/ROLLBACK后才会RELEASE。
45.YoufindthatthedatabaseperformancedegradeswhileyoubackupthePRODdatabaseusingRecoveryManager(RMAN).ThePRODdatabaseisrunninginsharedservermode.Thedatabaseinstanceiscurrentlyusing60%oftotaloperatingsystemmemory.Yoususpectthesharedpoolfragmentationtobethereason.
Whichactionwouldyouconsidertoovercometheperformancedegradation?
A)ConfigureJavaPooltocachethejavaobjects.
B)ConfigureStreamsPooltoenableparallelprocessing.
C)IncreaseSharedPoolsizetocachemorePL/SQLobjects.
D)IncreaseDatabaseBufferCachesizetoincreasecachehits.
E)ConfigureLargePooltobeusedbyRMANandsharedserver.
F)IncreasethetotalSystemGlobalArea(SGA)sizetoincreasememoryhits.
答案：E
在磁盘上的备份会使用PGA内存空间作为备份缓冲区，PGA内存空间从用于通道进程的内存空间中分配。如果操作系统没有配置本地异步I/O，可以利用DBWR_IO_SLAVES参数使用I/O从属来填充内存中的输入缓冲区。如果设置DBWR_IO_SLAVES参数为任意的非零值，RMAN会自动分配4个I/O从属协调输入缓冲区内存中的数据块加载。为了实现这一功能，RMAN必须利用一个共享内存区域。因此，用于磁盘备份的内存区会被推入共享池，如果存在large池，则被推入large池。
如果没有使用磁带I/O从属，会在PGA中分配用于磁带输出缓冲区的内存。设置init.ora参数BACKUP_TAPE_IO_SLAVES=TRUE，可以使用磁带I/O从属，必要时还可以在spfile里动态修改。该参数设为true时，rman会为每个通道创建一个从属进程来帮助备份工作。为了协调这一功能，RMAN会将内存分配推进SGA。
如果配置了任一种I/O从属选项并且没有配置large池，则会在SGA的共享池曲终分配内存。如果没有配置large池又要使用I/O从属，建议最好创建一个large池，这个large池的大小基于为备份分配的通道总数（加上1MB用于开销）。
RMAN系列（一）----RMAN体系结构概述
http://blog.****.net/tianlesoftware/archive/2010/06/09/5659701.aspx
46.Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase,youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective?
A)UsetheCREATEDATABASE..commandtocreatethedatabasewithOracle-managedfiles.
B)UsetheDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithOracle-managedfiles.
C)UseEnterpriseManagertocreateanewdatabasewiththeOnlineTransactionProcessing(OLTP)option.
D)UseDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithTransactionProcessingtemplate.
E)UsetheCREATEDATABASE..commandtocreatethedatabasewithAutomaticStorageManagement(ASM)filessystem.
答案：D
47.Whichtwostatementsaretrueabouttheprimarykeyconstraintinatable?(Choosetwo.)
A)Itisnotpossibletodisabletheprimarykeyconstraint.
B)Itispossibletohavemorethanoneprimarykeyconstraintinasingletable.
C)Theprimarykeyconstraintcanbereferredbyonlyoneforeignkeyconstraint.
D)Theprimarykeyconstraintcanbeimposedbycombiningmorethanonecolumn.
E)Thenon-deferrableprimarykeyconstraintcreatesanuniqueindexontheprimarykeycolumnifitisnotalreadyindexed.
答案：DE
48.ViewtheExhibittoseethestructureoftheEMPLOYEESandDEPARTMENTStables.
YourorganizationplanstodissolvethedepartmentwithdepartmentID30.Youexecutethefollowingcommandtodeleterows
fromtheDEPARTMENTStable:
SQL>deletefromDEPARTMENTS
whereDEPT_ID=30;
Thecommandfailsanddisplaysthefollowingerror:
ERRORatline1:
ORA-02292:integrityconstraint(HR.SYS_C005374)violated-childrecordfound
Whichtwoactionswouldyoutaketoovercomethiserror?(Choosetwo.)
A)altertheforeignkeyconstrainttoincludethecascadeoption
B)altertheforeignkeyconstrainttoincludetheondeletecascadeoption
C)first,droptheEMPLOYEEStableandthendeletetherowsfromtheDEPARTMENTStable
D)first,droptheDEPARTMENTStableandthendeletetherowsfromtheEMPLOYEEStable
E)first,deletealloftherowsfromEMPLOYEEStableandthendeletetherowsfromtheDEPARTMENTStablefordepartmentid30
F)first,deleterowsfromtheEMPLOYEEStablefordepartmentid30andthendeletetherowsfromtheDEPARTMENTStablefordepartmentid30
答案：BF
49.Whichtwooperationsrequireundodata?(Choosetwo.)
A)committingatransaction
B)rollingbackatransaction
C)recoveringfromfailedtransactions
D)recordingatransactiontoredologfiles
E)rollingforwardduringinstancerecovery
答案：BC
Undo里保存的数据前镜像，即数据修改之前，先将原始数据保存在undo里。而redo记录的是事务。
50.WhichtwostatementsaboutAutomaticStorageManagement(ASM)aretrue?(Choosetwo.)
A)ASMprovidesmirroringonfilebyfilebasis.
B)ASMprovidesautomaticloadbalancingacrossallASMdisks.
C)ASMsupportstheOracledatabaseandoperatingsystemfiles.
D)ASMcanbeusedtostoretracefiles,alertlogfiles,andtheserverparameterfile(SPFILE).
答案：AB
http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/asm.htm#ADMQS12100
51.Youexecutedthefollowingcommandtobackupyourcontrolfile:
ALTERDATABASEBACKUPCONTROLFILETOTRACE;
Whichinitializationparameterisusedtospecifythelocationofthetracefile?
A)USER_DUMP_DEST
B)CORE_DUMP_DEST
C)TRACE_DUMP_DEST
D)BACKUP_DUMP_DEST
E)BACKGROUND_DUMP_DEST
答案：A
52.Whichthreestatementsaretrueaboutthestagesofdatabasestartup?(Choosethree.)
A)DatafilesandredologfilescanberenamedattheMOUNTstage.
B)ControlfilesarereadattheOPENstageforthelocationofdatafiles.
C)ControlfilesarerequiredtobringthedatabasetotheNOMOUNTstage.
D)DatafilesandredologfilesaremadeavailabletousersattheOPENstage.
E)Datafilesandonlineredologfilesarecheckedforconsistencywhileopeningthedatabase.
答案：ADE
深刻理解Oracle数据库的启动和关闭
http://blog.****.net/tianlesoftware/archive/2009/10/21/4704877.aspx
53.TheemployeeIDsofemployeeswhohavemadesalesinthecompanyaretransferredfromtheEMPLOYEEStabletotheBONUStablewithadefaultbonusvalue.Later,thehumanresourcesdepartmentdecidestogivebonusestoemployeesasperthefollowingconditions:
1.Employeeswithasalaryof$8,000orlessshouldreceiveabonus.
2.Employeeswhohavenotmadesalesgetabonusof1%oftheirsalary.
3.Employeeswhoalreadymadesalesgetanincreaseintheirbonusequalto1%oftheirsalary.
Whatwouldyoudotoimplementthesechangesinonestep?
A)UseSQL*Loaderutility.
B)UsetheMERGEstatement.
C)Useamultitableinsertoperation.
D)UseacorrelatedUPDATEstatement.
答案：B
OracleMergeInto的用法详解实例
http://blog.****.net/tianlesoftware/archive/2009/10/23/4714921.aspx
54.Whichthreepiecesofinformationareconsideredwhiledecidingthesizeoftheundotablespaceinyourdatabase?(Choosethree.)
A)thesizeofanundoblock
B)thesizeoftheredologfiles
C)undoblocksgeneratedpersecond
D)thesizeofthedatabasebuffercache
E)thevalueoftheUNDO_RETENTIONparameter
答案：ACE
55.Examinethefollowingcommandsexecutedinyourdatabase:
SQL>ALTERSESSIONRECYCLEBIN=ON;
Sessionaltered
SQL>CREATETABLEempTABLESPACEtbsfdASSELECT*FROMhr.employees;
Tablecreated.
Further,youexecutedthefollowingcommandtodropthetable:
SQL>DROPTABLEemp;
Tabledropped.
Whathappensinthisscenario?
A)ThetableismovedtotheSYSAUXtablespace.
B)ThetableismovedtotheSYSTEMtablespace.
C)Thetableisremovedfromthedatabasepermanently.
D)ThetableisrenamedandremainsintheTBSFDtablespace.
答案：D
Therecyclebinisactuallyadatadictionarytablecontaininginformationaboutdroppedobjects.Droppedtablesandanyassociatedobjectssuchasindexes,constraints,nestedtables,andthelikesarenotremovedandstilloccupyspace.Theycontinuetocountagainstuserspacequotas,untilspecificallypurgedfromtherecyclebinortheunlikelysituationwheretheymustbepurgedbythedatabasebecauseoftablespacespaceconstraints.
Eachusercanbethoughtofashavinghisownrecyclebin,because,unlessauserhastheSYSDBAprivilege,theonlyobjectsthattheuserhasaccesstointherecyclebinarethosethattheuserowns.
http://download.oracle.com/docs/cd/E11882_01/server.112/e10595/tables011.htm#ADMIN11680
56.Youexecutethefollowingcommandtoauditthedatabaseactivities:
SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;
Whatistheeffectofthiscommand?
A)OneauditrecordiscreatedforthewholesessionifuserSCOTTsuccessfullydropsoneormoretablesinhissession.
B)OneauditrecordiscreatedforeverysessionwhenanyusersuccessfullydropsatableownedbySCOTT.
C)OneauditrecordiscreatedforeachsuccessfulDROPTABLEcommandexecutedbyanyusertodroptablesownedbySCOTT.
D)OneauditrecordisgeneratedforthesessionwhenSCOTTgrantstheDROPANYTABLEprivilegetootherusersinhissession.
E)OneauditrecordiscreatedforeachsuccessfulDROPTABLEcommandexecutedinthesessionofSCOTT.
答案：A
57.Youplantousestaticdatabaseregistrationforanewlistenerwhenyoucreateit.Whatcouldbethetworeasonsforthis?(Choosetwo.)
A)Morethanonedatabaseistoberegisteredwiththelistener.
B)Theuserswillconnectthedatabasebyusingthehostnamingmethod.
C)TheOracleEnterpriseManageristobeusedtomonitoranOracle9idatabase.
D)Thedatabasethatistoberegisteredwiththelistenerisconfiguredinsharedservermode.
E)Thelistenerisnotconfiguredonthedefaultportof1521andtheinstanceisnotconfiguredtoregisterwithanondefaultport.
答案：CE
58.Whichtwostatementsregardingarchivelogdestinationsaretrue?(Choosetwo.)
A)Amaximumof10destinationscanbespecified.
B)Thearchivelogsmustbewrittentoallthedestinations.
C)Thearchivelogfilescanbewrittenonlytolocaldestinations.
D)Thearchivinginformationcanbetracedtothealertlogfilewheneverthearchivingtoadestinationissuccessful.
E)Thenumberofarchivingdestinationsmustbeequaltothenumberofarchiveprocesses(ARCn).
答案：AD
59.DuetomediafailureyoulostoneofthedatafilesbelongingtotheUSERStablespace,andthetablespace
isnotavailabletouse.Whichstatementregardingthestatusofthedatabaseistrue?
A)Thedatabaseremainsopen.
B)Thedatabasegetsdismounted.
C)Thedatabasebecomesreadonly.
D)Thedatabaseinstancegetsaborted.
E)Thedatabasegetsshutdownautomatically.
F)ThestatusofthedatabasedependsonthestatusoftheUSERStablespace.
答案：A
60.YouexecutedthefollowingcommandtoexporttheEMPLOYEEStablefromaremoteMachine:
$EXPDPhr/[email protected]
DUMPFILE=my_dir)exp_hr.log
LOGFILE=data_pump_dir)log_hr.log
TABLES=employees
Whatwouldbetheoutcomeofthiscommand?
A)ThecommandwouldexecutesuccessfullyandtheexportdumpfilewouldbecreatedinthedestinationofthedirectoryobjectMY_DIR.
B)Thecommandwouldexecutesuccessfully.ButlogfilewouldnotbecreatedasDATA_PUMP_DIRdirectoryisonlyaccessibletouserwithSYSDBAprivilege.
C)ThecommandfailswithanerrorbecauseDATA_PUMP_DIRdirectoryhavehigherprecedenceovertheper-filedirectory.
D)Thecommandfailswithanerrorbecausenoabsolutepathisspecifiedforlogfileanddumpfile.
答案：A
61.ViewtheExhibit.
Whichstatementregardingthedeptandemptablesistrue?
A)Whenyoudeletearowfromtheemptable,youwouldreceiveaconstraintviolationerror.
B)Whenyoudeletearowfromthedepttable,youwouldreceiveaconstraintviolationerror.
C)Whenyoudeletearowfromtheemptable,automaticallythecorrespondingrowsaredeletedfromthedepttable.
D)Whenyoudeletearowfromthedepttable,automaticallythecorrespondingrowsaredeletedfromtheemptable.
E)Whenyoudeletearowfromthedepttable,automaticallythecorrespondingrowsareupdatedwithnullvaluesintheemptable.
F)Whenyoudeletearowfromtheemptable,automaticallythecorrespondingrowsareupdatedwithnullvaluesinthedepttable.
答案：D
62.Asaresultofperformanceanalysis,youcreatedanindexontheprod_namecolumnoftheprod_dettable,whichcontainsabouttenthousandrows.Later,youupdatedaproductnameinthetable.Howdoesthischangeaffecttheindex?
A)Aleafwillbemarkedasinvalid.
B)Anupdateinaleafrowtakesplace.
C)Theindexwillbeupdatedautomaticallyatcommit.
D)Aleafrowintheindexwillbedeletedandinserted.
E)Theindexbecomesinvalidwhenyoumakeanyupdates.
答案：D
63.YouscheduledabackupbyusingtheScheduleBackupoptioninOracleEnterpriseManager.WhichstatementaboutthescriptcreatedbyOracleEnterpriseManageristrue?
A)ItisaSQLscript.
B)ItisaPL/SQLfile.
C)Itisanoperatingsystem(OS)file.
D)ItisaRecoveryManager(RMAN)script.
答案：D
64.YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate?
A)renamingthecontrolfiles
B)droppingauserinyourdatabase
C)enablingordisablingredologarchiving
D)droppingatablespaceinyourdatabase
E)re-creatingthecontrolfiles,afteryoulostallthecontrolfilesinyourdatabase
答案：C
65.Youarecreatingalocallymanagedtablespacetomeetthefollowingrequirements:
Alltheextentsshouldbeofthesamesize.
Thedatashouldbespreadacrosstwodatafiles.
Abitmapshouldbeusedtorecordthefreespacewithintheallocatedextents.
Whichthreeoptionswouldyouchoose?(Choosethree.)
A)setPCTFREEandPCTUSEDto50
B)specifyextentallocationasUniform
C)specifyextentallocationasAutomatic
D)createthetablespaceasbigfiletablespace
E)createthetablespaceassmallfiletablespace
F)setsegmentspacemanagementtoAutomatic
G)usetheRESIZEclausewhilecreatingthetablespace
答案：BEF
66.Youcreatedaresponsefileandwanttocheckitbeforestartinginstallationsinsilentmode.YoustartedinstallationofOraclesoftwareininteractivemodebyprovidingtheresponsefile.Inthemiddleoftheinstallation,yourealizethatthebehavioroftheOracleUniversalInstaller(OUI)isnotconsistentwiththeresponsefile.
Whatactionwouldyoutaketodetectthecauseofthisbehavior?
A)Comparethecontentsoftheinstall.logfilewiththeresponsefile.
B)RefertothecontentsoftheoraInst.locfiletoverifythestepsperformedbyOUI.
C)ComparethecontentsoftheinstallActions.logfilewiththatoftheresponsefile.
D)RefertothealertlogfileforinformationregardingtheactionsperformedbyOUIduringinstallation.
答案：C
67.YourdatabaseisconfiguredwiththefollowingparametersrelatedtoSGA)
SGA_TARGET=256MB
SHARED_POOL_SIZE=32MB
DB_CACHE_SIZE=100MB
LARGE_POOL_SIZE=0
JAVA_POOL_SIZE=0
STREAMS_POOL_SIZE=0
Whichtwostatementsaretrueabouttheconfiguration?(Choosetwo.)
A)TheSGA_TARGETvaluecannotbesizedsmallerthan100MB.
B)Thesharedpoolandthedefaultbufferpoolwillnotbesizedbiggerthan32MBand100MB,respectively.
C)Thesharedpoolandthedefaultbufferpoolwillnotbesizedsmallerthan32MBand100MB,respectively.
D)124MB(256minus132)ofmemoryisavailableforusebyallthemanuallysizedcomponents.
E)124MB(256minus132)ofmemoryisavailableforusebyallthemanuallyandautomaticallysizedcomponents.
答案：CE
68.Yoususpectunauthorizeddatamanipulationlanguage(DML)operationsonaparticulartable.Youwanttotrackuserswhoareperformingthetransactionsandthevaluesusedinthetransactions.Also,youplantotransferthesevaluestoanothertableforanalysis.
Howwouldyouachievethis?
A)byusingtriggers
B)byusingexternaltables
C)byusinganonymousPL/SQLblocks
D)byauditingallDMLoperationsonthetable
答案：A
69.WhichtwostatementsaretrueabouttheAutomaticDatabaseDiagnosticMonitor(ADDM)?(Choosetwo.)
A)TheADDMrunsaftereachAWRsnapshotiscollected.
B)TheADDMrequiresatleastfourAWRsnapshotsforanalysis.
C)TheADDManalysisprovidesonlythediagnosticinformationbutdoesnotproviderecommendations.
D)TheresultsoftheADDManalysisarestoredintheAutomaticWorkloadRepository(AWR).
E)TheADDMcallsotheradvisorsifrequired,butdoesnotproviderecommendationsabouttheadvisors.
答案：AD
OracleADDM自动诊断监视工具介绍
http://blog.****.net/tianlesoftware/archive/2010/05/29/5630942.aspx
70.Whichstatementistrueaboutthelossofsystem-criticaldatafilesinARCHIVELOGmode?
A)Thedatafilescanberecoveredtillthelastcommittedtransaction.
B)Thedatafilescanberecoveredwithoutshuttingdownthedatabase.
C)Thedatafileistakenofflineautomatically;thedatabaseremainsopen.
D)Thedatafilescanberecoveredtothetimeofthemostrecentbackup.
答案：A
------------------------------------------------------------------------------
Blog：http://blog.****.net/tianlesoftware
网上资源：http://tianlesoftware.download.****.net
相关视频：http://blog.****.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1群：62697716(满);DBA2群：62697977
DBA3群：63306533;聊天群：40132017