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.csdn.net/tianlesoftware/archive/2009/11/30/4901666.aspx

Oracleundo表空间管理

http://blog.csdn.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.csdn.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.csdn.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.csdn.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.csdn.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/[e-mail]

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.csdn.net/tianlesoftware/archive/2010/05/29/5630942.aspx

70.Whichstatementistrueaboutthelossofsystem-criticaldatafilesinARCHIVELOGmode?

A)Thedatafilescanberecoveredtillthelastcommittedtransaction.

B)Thedatafilescanberecoveredwithoutshuttingdownthedatabase.

C)Thedatafileistakenofflineautomatically;thedatabaseremainsopen.

D)Thedatafilescanberecoveredtothetimeofthemostrecentbackup.

答案：A

------------------------------------------------------------------------------

Blog：http://blog.csdn.net/tianlesoftware

网上资源：http://tianlesoftware.download.csdn.net

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1群：62697716(满);DBA2群：62697977

DBA3群：63306533;聊天群：40132017

<!--EndFragment-->