Oracle 10g OCP 042 题库 71-120 题共168题-优快云博客

71.Yourdatabaseinstanceisstartedusingtheserverparameterfile(SPFILE).Controlfilesaremultiplexedandstoredondifferentdisks.Becauseofadiskfailure,youlostoneofthesecontrolfiles.Youreplacedthedamageddisk.Whatisthecorrectsequenceofstepsthatyouwouldfollowtorecoverthecontrolfile?

1.shutdowntheinstance,ifnotalreadydone.

2.Copyoneoftheremainingcontrolfilestoanewlocation.

3.ChangethevalueoftheCONTROL_FILESinitializationparametertocorrespondtothenewlocationofthecontrolfiles.

4.StartupthedatabaseinstancetotheNOMOUNTstage.

5.Recoverthedatabasetothepointoffailureofthecontrolfile.

6.Openthedatabase.

A)5,2,3,4

B)1,2,4,3,5

C)2,4,3,4,5

D)4,5,6,2,3

答案：B

72.TheSAVE_AMTcolumnintheACCOUNTStablecontainsthebalancedetailsofcustomersinabank.Aspartoftheyear-endtaxandinterestcalculationprocess,alltherowsinthetableneedtobeaccessed.Thebankauthoritieswanttotrackaccesstotherowscontainingbalanceamountsexceeding$200,000,andthensendanalertmessagetotheadministrator.Whichmethodwouldyousuggesttothebankforachievingthistask?

A)implementingvalue-basedauditingbyusingtriggers

B)implementingfine-grainedauditingwithauditconditionandeventhandler

C)performingstandarddatabaseauditingtoauditobjectprivilegesbysettingtheAUDIT_TRAILparametertoEXTENDED

D)performingstandarddatabaseauditingtoauditSQLstatementswithgranularitylevelsettoACCESS

答案：B

73.TheuserSCOTTexecutesthefollowingcommandsuccessfullytoincreasethesalaryvaluesinoneofhissessions:

SQL>UPDATEempSETsal=sal*1.15WHEREdeptno=20;

BeforeSCOTTendsthetransaction,userHRwhohastheprivilegesonEMPtableexecutesaquerytofetchthesalarydetailsbutfindstheoldsalaryvaluesinsteadoftheincreasedvalues.

WhydoesHRstillseetheolddata?

A)becauseofredodatafromredologfile

B)becauseofdatafromdatabasebuffercache

C)becauseofdatafromatemporarytablespace

D)becauseofundodatafromtheundotablespace

答案：D

74.ViewtheExhibitandexaminetheoutput.

Whichstatementdescribestheconclusion?

A)Theusersshouldusebindvariablesinsteadofliteralsinthequery.

B)Thedictionarycacheisconsumingmorespacethanthelibrarycache.

C)ThesharedpoolsizeshouldbeincreasedtoaccommodatetheSQLstatements.

D)PreparingindexesonthetablesusedintheSQLstatementswouldimprovethelibrarycacheperformance.

答案：A

Oracle绑定变量

http://blog.youkuaiyun.com/tianlesoftware/archive/2009/10/17/4678335.aspx

75.Inyourdatabase,theLogWriter(LGWR)processisunabletowritetoamemberofacurrentredologgroupduetoread/writefailure.Whichtwoeffectswouldyouseeinyourdatabase?(Choosetwo.)

A)Thedatabaseinstanceaborts.

B)Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.

C)Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.

D)ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.

E)ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.

答案：CD

76.Yourdatabaseisnotconfiguredforsessionfailover.Yourtnsnames.orafilecontainsthefollowingdetails:

test.us.oracle.com=

(DESCRIPTION=

(ADDRESS_LIST=

(LOAD_BALANCE=off)

(FAILOVER=ON)

(ADDRESS=(PROTOCOL=tcp)(HOST=test1-server)(PORT=1521))

(ADDRESS=(PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))

(CONNECT_DATA=(SERVICE_NAME=test.us.oracle.com)))

Whichfeatureisenabledinthiscase?

A)Loadbalancing

B)Instancefailover

C)Databasefailover

D)Connect-timefailover

E)TransparentApplicationFailover(TAF)

答案：D

77.OnwhichthreecanyouuseRecoveryManager(RMAN)toperformincrementalbackup?(Choosethree.)

A)datafiles

B)controlfiles

C)tablespaces

D)passwordfile

E)parameterfile

F)wholedatabase

G)flashbacklogfile

H)archivedlogfiles

I)changetrackingfile

答案：ACF

78.YoudefineanalerttoberaisedwhentheUSERStablespaceusagehasreached80%ofthetotalspace.

Whichareawouldyoureferto,inordertoconfirmthatthealerthasbeenraisedduetheevent?

A)thealert.logfile

B)theDBA_ALERTSview

C)theDatabaseControlHomepage

D)theDatabaseControlperformancepage

E)theDatabaseControlMaintenancepage

答案：C

79.AusercomplainsthathegetsthefollowingerrormessagerepeatedlyafterexecutingsomeSQLstatements.Theerrormessageforcestheusertologofffromandlogontothedatabasetocontinuehiswork.

ORA-02392:exceededsessionlimitonCPUusage,youarebeingloggedoff

WhichactionwouldyoutaketoincreasethesessionlimitonCPUusage?

A)Modifytheprofileassignedtotheuser.

B)Modifytherolesassignedtotheusers.

C)Modifytheobjectprivilegesassignedtotheuser.

D)Modifythesystemprivilegesassignedtotheusers.

E)ModifythevaluefortheRESOURCE_LIMITparameterintheparameterfile.

答案：A

80.Youexecutethefollowingcommandtoauditthedatabaseactivities:

SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;

Whatistheeffectofthiscommand?

A)OneauditrecordiscreatedforthewholesessionifuserSCOTTsuccessfullydropsoneormoretablesinhissession.

B)OneauditrecordiscreatedforeverysessionwhenanyusersuccessfullydropsatableownedbySCOTT.

C)OneauditrecordiscreatedforeachsuccessfulDROPTABLEcommandexecutedbyanyusertodroptablesownedbySCOTT.

D)OneauditrecordisgeneratedforthesessionwhenSCOTTgrantstheDROPANYTABLEprivilegetootherusersinhissession.

E)OneauditrecordiscreatedforeachsuccessfulDROPTABLEcommandexecutedinthesessionofSCOTT.

答案：A

81.WhichthreedescriptionsarecorrectabouttheeffectsoftheTRUNCATEcommandonatable?(Choosethree.)

A)Thecorrespondingindexesforthetablearealsotruncated.

B)DeletetriggersonthetablearefiredduringtheexecutionoftheTRUNCATEcommand.

C)VerylittleornoundodataisgeneratedduringtheexecutionoftheTRUNCATEcommand.

D)ThechildtableistruncatedwhentheTRUNCATEcommandisappliedontheparenttable.

E)Thehigh-watermark(HWM)issettopointtothefirstuseabledatablockinthetablesegment.

答案：ACE

Iftableisnotempty,thenthedatabasemarksUNUSABLEallnonpartitionedindexesandallpartitionsofglobalpartitionedindexesonthetable.However,whenthetableistruncated,theindexisalsotruncated,andanewhighwatermarkiscalculatedfortheindexsegment.Thisoperationisequivalenttocreatinganewsegmentfortheindex.Therefore,attheendofthetruncateoperation,theindexesareonceagainUSABLE.

http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/statements_10007.htm#SQLRF01707

82.WhichisthecorrectdescriptionofthesignificanceoftheORACLE_HOMEenvironmentalvariable?

A)ItspecifiesthedirectorycontainingtheOraclesoftware.

B)ItspecifiesthedirectorycontainingtheOracle-ManagedFiles.

C)Itspecifiesthedirectoryfordatabasefiles,ifnotspecifiedexplicitly.

D)ItspecifiesthebasedirectoryofOptimalFlexibleArchitecture(OFA).

答案：A

83.YourtestdatabaseisrunninginNOARCHIVELOGmode.Whataretheimplicationsofthis?

A)Youcanperformopendatabasebackups.

B)Youcanperformcloseddatabasebackups.

C)Youcannotperformschema-levellogicalbackups.

D)YoucanperformthebackupofonlytheSYSTEMtablespacewhenthedatabaseisopen.

答案：B

84.ViewtheExhibittoobservetherolesassignedtotheSCOTTuser.

WhichstatementistrueabouttheassignmentoftheSELECT_CATALOG_ROLEroletotheSCOTTuser?

A)Theusercannotusetheroleatall.

B)Theusercangranttheroletootherusers.

C)Theuserneedstoenabletheroleexplicitly.

D)Theusercanstartusingtheroleimmediately.

答案:C

85.Youareusingflatfilesasthedatasourceforoneofyourdatawarehousingapplications.YouplantomovethedatafromtheflatfilestructurestoanOracledatabasetooptimizetheapplicationperformance.Inyourdatabaseyouhaveclusteredtables.Whilemigratingthedata,youwanttohaveminimalimpactonthedatabaseperformanceandoptimizethedataloadoperation.WhichmethodwouldyouusetoloaddataintoOracledatabase?

A)usetheexternaltablepopulation

B)usetheOracleDataPumpexportandimportutility

C)usetheconventionalpathdataloadofSQL*Loaderutility

D)usethedirectpathdataloadofOracleexportandimportutility

答案：C

86.YouareworkingonadatabasecreatedwiththeOracleDatabase10gsoftwareinwhichtheinitializationparameterCOMPATIBLEissetto10.0.0.Thehr_tbstablespaceinthedatabaseiscreatedasfollows:

CREATETABLESPACEhr_tbsDATAFILE'/oracle/oradata/hr_tbs.dbf'SIZE50M;

ViewtheExhibittoseethepropertiesofthedatabase.

Whichstatementiscorrectinthisscenario?

A)hr_tbsisabigfiletablespace.

B)hr_tbsisadictionary-managedtablespace.

C)Allthetablespacesinthedatabasewillbelocallymanagedbydefault.

D)Allthetablespacesinthedatabasemustbeofthesmallfiletablespacetype.

E)Thetablespacetypebigfileorsmallfilemustbementionedinthecommand.

答案：C

87.ViewtheExhibitandanalyzetheCREATETABLEstatementsusedtocreatetheITEMSandORDERStables.TheITEMStablehas50rowsandORDERStablehas500rows.Becauseyoudecidetonotdealwiththeitemcode188infuture,youexecutethefollowingcommandtoremovetheitem:

SQL>DELETEFROMitemsWHEREitem_code=188;

Whatistheeffectofthiscommand?

A)Thecommandfailswithintegrityviolationerror.

B)Therowcontainingthevalue188correspondingtotheITEM_CODEcolumnisdeletedfromtheITEMStable,andtheforeignkeyconstraintisdisabledintheORDERStable.

C)Therowcontainingthevalue188correspondingtotheITEM_CODEcolumnisdeletedfromtheITEMStable,andthedependentrowsintheORDERStablearealsodeletedautomatically.

D)Therowcontainingthevalue188correspondingtotheITEM_CODEcolumnisdeletedfromtheITEMStable,andthedependentrowsintheORDERStablearepopulatedwithNULLvaluesintheirITEM_CODEcolumns.

答案：C

88.Auserreceivesthefollowingerrorwhileexecutingaquery:

ORA-01555:snapshottooold

Whichtwooptionscanbethesolutionstoavoidsucherrorsinfuture?(Choosetwo.)

A)increasethesizeofredologfiles

B)increasethesizeoftheundotablespace

C)increasethesizeoftheDatabaseBufferCache

D)increasethesizeofthedefaulttemporarytablespace

E)enabletheretentionguaranteefortheundotablespace

答案：BE

OracleORA-01555快照过旧

http://blog.youkuaiyun.com/tianlesoftware/archive/2009/10/31/4745898.aspx

89.Youhaveatextfilethatmaintainsinformationonthousandsofitems.Theend-userapplicationrequiresthetransferofthatinformationintoatableinthedatabase.Whatwouldyouusetoachievethistask?(Choosetwo.)

A)OracleText

B)DataPump

C)SQL*Loader

D)OracleImport

E)Externaltable

答案：CE

90.Redologfilesarenotmultiplexedinyourdatabase.Redologblocksarecorruptedingroup2,andarchivinghasstopped.Alltheredologsarefilledanddatabaseactivityishalted.Databasewriterhaswritteneverythingtodisk.

Whichcommandwouldyouexecutetoproceedfurther?

A)RECOVERLOGFILEBLOCKGROUP2;

B)ALTERDATABASEDROPLOGFILEGROUP2;

C)ALTERDATABASECLEARLOGFILEGROUP2;

D)ALTERDATABASERECOVERLOGFILEGROUP2;

E)ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP2;

答案：E

91.YourdatabaseisopenandyouplantoperformRecoveryManager(RMAN)backups.Whichthreestatementsaretrueaboutthesebackups?(Choosethree.)

A)Thebackupswouldbeconsistent.

B)Thebackupswouldbeinconsistent.

C)Thebackupsneedtoberestoredanddatabasehastoberecoveredincaseofamediafailure.

D)Thebackupsneednotberestoredduringrecoveryincaseofamediafailure.

E)ThebackupswouldbepossibleonlyifthedatabaseisrunninginARCHIVELOGmode.

F)ThebackupswouldbepossibleonlyifthedatabaseisrunninginNOARCHIVELOGmode.

答案：BCE

92.YouwanttheuserAPP_DBAtoadministertheOracledatabasefromaremotemachine.APP_DBAisgrantedtheSYSDBAprivilegetoperformadministrativetasksonthedatabase.

WhichfileisusedbytheOracledatabaseservertoauthenticateAPP_DBA?

A)controlfile

B)passwordfile

C)listenercontrollerfile

D)controlfileandpasswordfile

答案：B

Sysdba的密码是保存在密码文件中的。

93.Yourdatabaseishavingtwocontrolfiles,threeredologfilegroupswithtwomembersineachgroup.Failureofwhichfilewouldcauseaninstancetoshutdown?

A)anycontrolfile

B)anyarchivelogfile

C)oneoftheredologmembers

D)lossoftheinitializationparameterfile

E)anydatafilebelongingtothedefaultpermanenttablespace

答案：A

94.TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andundoretentionisnotguaranteed.

Whichstatementregardingretentionofundodataiscorrect?

A)Undodatabecomesobsoleteafter1,000seconds.

B)Undodatagetsrefreshedafterevery1,000seconds.

C)Undodatawillbestoredpermanentlyafter1,000seconds.

D)Committedundodatawouldberetainedfor1,000secondsiffreeundospaceisavailable.

E)UndodatawillberetainedintheUNDOtablespacefor1,000seconds,thenitgetsmovedtotheTEMPORARYtablespacetoprovidereadconsistency.

答案：D

Oracleundo表空间管理

http://blog.youkuaiyun.com/tianlesoftware/archive/2010/07/11/5689558.aspx

95.Yourdatabaseisfunctionalwithpeakloadforonehour.Youwanttopreservetheperformancestatisticscollectedduringthisperiodsothattheycanbeusedforcomparisonwhileanalyzingtheperformanceofthedatabaseinthefuture.Whatactionwouldyoutaketoachievethistask?

A)SettheSTATISTICS_LEVELinitializationparametertoALL.

B)Createabaselineonapairofsnapshotsthathavethestatisticsofthepeak-loadperiodinthedatabase.

C)DecreasethesnapshotintervalintheAWRtocollectmorenumberofsnapshotsduringthepeak-loadperiod.

D)SetthesnapshotretentionperiodintheAutomaticWorkloadRepository(AWR)tozerotoavoidtheautomaticpurgingofthesnapshots.

答案：B

96.WhichstatementistruewhenyouruntheSQLTuningAdvisorwithlimitedscope?

A)AccesspathanalysisisnotperformedfortheSQLstatements.

B)SQLstructureanalysisisnotperformedfortheSQLstatements.

C)SQLProfilerecommendationsarenotgeneratedfortheSQLstatements.

D)ThestalenessandabsenceofthestatisticsarenotcheckedfortheobjectsinthequerysuppliedtotheSQLTuningAdvisor.

答案：C

97.Youspecifiedsegmentspacemanagementasautomaticforatablespace.Whateffectwouldthishaveonspacemanagement?

A)Extentswouldbemanagedbythefreelists.

B)Thesegmentwouldbemanagedbybitmaps.

C)Thesegmentwouldbemanagedbythefreelists.

D)Freespacewouldbemanagedbythedatadictionary.

答案：B

98.Whichtwostatementsaboutbigfiletablespacesaretrue?(Choosetwo.)

A)Thebigfiletablespacehaveonlyonedatafile.

B)Thesegmentspacemanagementisautomatic.

C)Theextentmanagementisdictionarymanaged.

D)Thedatabasecanhaveonlyonebigfiletablespace.

E)Thebigfiletablespacecanbeconvertedtoasmallfiletablespace.

答案：AB

99.YouwanttosetuptheOracleDatabase10ginstallationtofollowtheFrenchlanguage,withFranceastheterritory,andthedatetobedisplayedinFrenchforallusers'sessions.Whichenvironmentalvariablewouldyousettoachievethisobjective?

A)NLS_LANG

B)NLS_LANGUAGE

C)NLS_TERRITORY

D)NLS_CHARACTERSET

E)NLS_DATE_LANGUAGE

F)NLS_LENGTH_SEMANTICS

G)NLS_NCHAR_CHARACTERSET

答案：A

Oracle字符集的查看和修改

http://blog.youkuaiyun.com/tianlesoftware/archive/2009/12/02/4915223.aspx

100.Youwanttorefertheemployeepersonalinformationstoredinoperatingsystem(OS)filesinEMPLOYEEtable.YouplantoaddanewcolumntoEMPLOYEEtabletoachievethis.

Whichdatatypewouldyouuseforthenewcolumn?

A)BLOB

B)CLOB

C)BFILE

D)LONGRAW

答案：C

TheBFILEdatatypeenablesaccesstobinaryfileLOBsthatarestoredinfilesystemsoutsideOracleDatabase.ABFILEcolumnorattributestoresaBFILElocator,whichservesasapointertoabinaryfileontheserverfilesystem.Thelocatormaintainsthedirectorynameandthefilename.

http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/sql_elements001.htm#SQLRF50996

101.ViewtheExhibit.

Whichstatementcausesmoreundogeneration?

A)SELECT*FROMemp;

B)DELETEFROMempWHEREempno=7934;

C)UPDATEempSETcomm=400WHEREempno=7844;

D)INSERTINTOempVALUES(7999,'JHON','CLERK',7782,'10-MAY-83',1500,NULL,10);

答案：B

102.InwhichsituationwouldyouusetheOracleSharedServerconfiguration?

A)whenperformingexportandimportusingOracleDataPump

B)whenperformingbackupandrecoveryoperationsusingOracleRecoveryManager

C)whenperformingbatchprocessingandbulkloadingoperationinadatawarehouseenvironment

D)inanonlinetransactionprocessing(OLTP)systemwherelargenumberofclientsessionsareidlemostofthetime

答案：D

103.ThesessionofuserSCOTTreceivesthefollowingerrorafterexecutinganUPDATEcommandontheEMPtable:

ERRORatline1:

ORA-00060:deadlockdetectedwhilewaitingforresource

Oninvestigation,youfindthatasessionopenedbyuserJIMhasatransactionthatcausedthedeadlock.

WhichtwostatementsaretrueregardingthesessionofSCOTTinthisscenario?(Choosetwo.)

A)ItisterminatedafterreceivingtheerrorandJIMcancontinuewithhistransaction.

B)ThetransactioninitisterminatedafterreceivingtheerrorandJIMcancontinuewithhistransaction.

C)SCOTTshouldperformaCOMMITorROLLBACKtoallowJIMtocontinuewithhistransaction.

D)SCOTThastoreexecutethelastcommandinthetransactionafterhecommitsthetransaction.

答案：CD

104.AconstraintinatableisdefinedwiththeINITIALLYIMMEDIATEclause.YouexecutedtheALTERTABLEcommandwiththeENABLEVALIDATEoptiontoenabletheconstraintthatwasdisabled.Whatarethetwoeffectsofthiscommand?(Choosetwo.)

A)Itfailsifanyexistingrowviolatestheconstraint.

B)Itdoesnotvalidatetheexistingdatainthetable.

C)Itenablestheconstrainttobeenforcedattheendofeachtransaction.

D)Itpreventsinsert,update,anddeleteoperationsonthetablewhiletheconstraintisintheprocessofbeingenabled.

答案：AD

TheINITIALLYclauseestablishesthedefaultcheckingbehaviorforconstraintsthatareDEFERRABLE.TheINITIALLYsettingcanbeoverriddenbyaSETCONSTRAINT(S)statementinasubsequenttransaction.

SpecifyINITIALLYIMMEDIATEtoindicatethatOracleshouldcheckthisconstraintattheendofeachsubsequentSQLstatement.IfyoudonotspecifyINITIALLYatall,thenthedefaultisINITIALLYIMMEDIATE.

IfyoudeclareanewconstraintINITIALLYIMMEDIATE,thenitmustbevalidatthetimetheCREATETABLEorALTERTABLEstatementiscommittedorthestatementwillfail.

SpecifyINITIALLYDEFERREDtoindicatethatOracleshouldcheckthisconstraintattheendofsubsequenttransactions.

ThisclauseisnotvalidifyouhavedeclaredtheconstrainttobeNOTDEFERRABLE,becauseaNOTDEFERRABLEconstraintisautomaticallyINITIALLYIMMEDIATEandcannoteverbeINITIALLYDEFERRED.

http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/clauses002.htm#SQLRF52180

105.WhichstatementregardingthecontentsoftheV$PARAMETERviewistrue?

A)displaysonlythelistofdefaultvalues

B)displaysonlythelistofallbasicparameters

C)displaysthecurrentlyineffectparametervalues

D)displaysonlythelistofalladvancedparameters

E)displaysthelistofalltheparameterfilesofadatabase

F)displaysthecurrentcontentsoftheserverparameterfile

答案：C

106.TheHRuserownstheEMPtable.TheHRusergrantsprivilegestotheSCOTTuserbyusingthiscommand:

SQL>GRANTSELECT,INSERT,UPDATEONempTOscottWITHGRANTOPTION;

TheSCOTTuserexecutesthiscommandtograntprivilegestotheJIMuser:

SQL>GRANTSELECT,INSERT,UPDATEONhr.empTOjim;

NowtheHRuserdecidestorevokeprivilegesfromJIMbyusingthiscommand:

SQL>REVOKESELECT,INSERT,UPDATEONempFROMjim;

WhichstatementistrueafterHRissuestheREVOKEcommand?

A)ThecommandsucceedsandprivilegesarerevokedfromJIM.

B)ThecommandfailsbecauseSCOTTstillhasprivilegeswithhim.

C)ThecommandfailsbecauseHRcannotrevoketheprivilegesfromJIM.

D)OnlyHRcanperformSELECT,INSERT,andUPDATEoperationsontheEMPtable.

答案：C

107.YourdatabaseisrunningunderautomaticundomanagementandtheUNDO_RETENTIONparameterissetto900sec.Youexecutedthefollowingcommandtoenableretentionguarantee:

SQL>ALTERTABLESPACEundotbs1RETENTIONGUARANTEE;

Whateffectwouldthisstatementhaveonthedatabase?

A)Theextentsinundotablespaceretaindatauntilthenextfulldatabasebackup.

B)Theextentscontainingcommitteddataintheundotablespaceareneveroverwritten.

C)Theextentswhichnolongercontainuncommitteddataintheundotablespacearenotoverwrittenforatleast15minutes.

D)Theextentscontainingcommitteddataintheundotablespacearenotoverwrittenuntiltheinstanceisshutdown.

答案：C

108.Inyourdatabase,thesnapshotintervalissetto10minutesfortheAutomaticWorkloadRepository(AWR).Thedatabaseinstanceisrunningforthepast30days.

ViewtheExhibittoexaminetheAutomaticDatabaseDiagnosticMonitor(ADDM)task.

TheADDMtaskisperformedevery10minutes,exceptthelasttask.Whatcouldbethereasonforthis?

A)ThesnapshotretentionperiodfortheAWRwasincreasedbeforethelasttask.

B)Theoptimizerstatisticsforfewobjectsinthedatabasewerelockedbeforethelasttask.

C)TheSTATISTICS_LEVELinitializationparameterwaschangedtoBASICandresettoTYPICALbeforethelasttask.

D)TheoptimizerstatisticswascollectedmanuallybyusingtheDBMS_STATSpackagebeforethelasttask.

答案：C

STATISTICS_LEVELspecifiesthelevelofcollectionfordatabaseandoperatingsystemstatistics.TheOracleDatabasecollectsthesestatisticsforavarietyofpurposes,includingmakingself-managementdecisions.

ThedefaultsettingofTYPICALensurescollectionofallmajorstatisticsrequiredfordatabaseself-managementfunctionalityandprovidesbestoverallperformance.Thedefaultvalueshouldbeadequateformostenvironments.

WhentheSTATISTICS_LEVELparameterissettoALL,additionalstatisticsareaddedtothesetofstatisticscollectedwiththeTYPICALsetting.TheadditionalstatisticsaretimedOSstatisticsandplanexecutionstatistics.

SettingtheSTATISTICS_LEVELparametertoBASICdisablesthecollectionofmanyoftheimportantstatisticsrequiredbyOracleDatabasefeaturesandfunctionality,

http://download.oracle.com/docs/cd/E11882_01/server.112/e10820/initparams247.htm#REFRN10214

109.WhichtwostatementsaboutFlashbackQueryaretrue?(Choosetwo.)

A)Itisgeneratedbyusingtheredologfiles.

B)Ithelpsinrow-levelrecoveryfromusererrors.

C)ItcanbeperformedtorecoverALTERTABLEstatements

D)Itfailswhenundodatapertainingtothetransactionisoverwritten.

E)ThedatabasehastobeopenedwiththeresetlogsoptionafterperformingFlashbackQuery.

答案：BD

110.WhataretheconsequencesofexecutingtheSHUTDOWNABORTcommand?(Choosetwo.)

A)Thedatabasefilesaresynchronized.

B)Uncommittedchangesarenotrolledback.

C)Thedatabaseisclosed,buttheinstanceisstillstarted.

D)Databasebuffersandredobuffersarenotwrittentothedisk.

E)Thedatabaseundergoesautomaticmediarecoveryduringthenextstartup.

答案：BD

111.Whichthreestatementsarecorrectabouttemporarytables?(Choosethree.)

A)Indexesandviewscanbecreatedontemporarytables.

B)Boththedataandthestructureoftemporarytablescanbeexported.

C)Temporarytablesarealwayscreatedinauser'stemporarytablespace.

D)Thedatainsertedintoatemporarytableinasessionisavailabletoothersessions.

E)Datamanipulationlanguage(DML)locksareneveracquiredonthedataoftemporarytables.

答案：ACE

Oracle临时表

http://blog.youkuaiyun.com/tianlesoftware/archive/2009/10/21/4705283.aspx

112.Auserwantstoconnecttothedatabaseinstancefromanapplicationthatisrunningonaremotemachine.WhichtoolsshouldtheDBAusetoestablishtherequiredconfigurationtoensurethattheuserisabletoconnecttothedatabaseinstance?(Choosetwo.)

A)DataPump

B)OracleNetManager

C)OracleEnterpriseManager

D)OracleUniversalInstaller(OUI)

E)DatabaseConfigurationAssistant(DBCA)

答案：BC

113.Whileplanningtomanagemorethanonedatabaseinyoursystem,youperformthefollowingactivities:

1.Organizedifferentcategoriesoffilesintoindependentsubdirectories.

2.Useconsistentnamingconventionfordatabasefiles.

3.Separateadministrativeinformationpertainingtoeachdatabase.

Whichoptioncorrespondstothetypeofactivitiesperformedbyyou?

A)OracleManagedFiles

B)OracleGridArchitecture

C)OptimalFlexibleArchitecture

D)Oracledatabasearchitecture

答案：C

TheOptimalFlexibleArchitecturestandardhelpsyoutoorganizedatabasesoftwareandconfiguredatabasestoallowmultipledatabases,ofdifferentversions,ownedbydifferentuserstocoexist.OptimalFlexibleArchitectureassistsinidentificationofORACLE_BASEwithitsAutomaticDiagnosticRepository(ADR)diagnosticdatatoproperlycollectincidents.

AllOraclecomponentsontheinstallationmediaarecompliantwithOptimalFlexibleArchitecture.Thismeans,OracleUniversalInstallerplacesOracleDatabasecomponentsindirectorylocations,assigningthedefaultpermissionsthatfollowOptimalFlexibleArchitectureguidelines.

OraclerecommendsthatyouuseOptimalFlexibleArchitecture,speciallyifthedatabasewillgrowinsize,orifyouplantohavemultipledatabases.

http://download.oracle.com/docs/cd/E11882_01/install.112/e10848/appendix_ofa.htm#sthref698

114.Youspecifiedextentmanagementaslocalforatablespace.Howwillitaffectspacemanagementinthetablespace?

A)Alltheextentswillbeofthesamesize.

B)Bitmapwillbeusedtorecordfreeandallocatedextents.

C)Freeextentswillbemanagedbythedatadictionarytables.

D)Thetablespacewillbesystemmanagedandtheuserscannotspecifytheextentsize.

答案：B

115.ViewtheExhibittoexaminetheoutputoftheDBA_OUTSTANDING_ALERTview.

After30minutes,youexecutedthefollowingcommand:

SQL>SELECTreason,metric_valueFROMdba_outstanding_alerts;

REASONMETRIC_VALUE

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

Tablespace[TEST]is[28percent]full28.125

Whatcouldbethetworeasonsfortheeliminationoftheotherrowsintheoutput?(Choosetwo.)

A)Thethresholdalertconditionsarecleared.

B)ThethresholdalertsaretransferredtoDBA_ALERT_HISTORY.

C)Thenon-threshold-basedalertsaretransferredtoDBA_ALERT_HISTORY.

D)ThethresholdalertsrelatedtodatabasemetricsarepermanentlystoredinDBA_ALERT_HISTORYbutnotthethresholdalertsrelatedtoinstancemetrics.

答案：AB

116.WhichtwostatementsaretrueregardingtheSGA_TARGETinitializationparameter?(Choosetwo.)

A)ItcanbeincreaseduptothevalueoftheSGA_MAX_SIZEparameter.

B)IncreasingthevalueofSGA_TARGETuptothevalueofSGA_MAX_SIZEdisablestheautomaticsharedmemorymanagementfeature.

C)ReducingthevalueoftheSGA_TARGETparametertakesawaymemoryfrombothautotunedandmanuallysizedcomponents.

D)IncreasingthevalueoftheSGA_TARGETparameterdistributestheincreasedmemoryamongalltheautotunedcomponents.

答案：AD

117.Youworkinadatawarehouseenvironmentthatinvolvestheexecutionofcomplexqueries.ThecurrentcontentoftheSQLcacheholdstheidealworkloadforanalysis.

Youwanttoanalyzeonlyfewmostresource-intensivestatements.Whatwouldbeyoursuggestiontoreceiverecommendationsontheefficientuseofindexesandmaterializedviewstoimprovequeryperformance?

A)RuntheSQLAccessAdvisor.

B)RuntheSQLTuningAdvisor(STA).

C)RuntheAutomaticWorkloadRepository(AWR)report.

D)RuntheAutomaticDatabaseDiagnosticMonitor(ADDM).

答案：A

118.Younoticethiswarninginthealertlogfile:

ORA-19815:WARNING:db_recovery_file_dest_sizeof3221225472bytesis100.00%used,andhas0remainingbytesavailable.

WhatwouldyoudotoreclaimtheusedspaceintheFlashRecoveryArea?

A)BackuptheFlashRecoveryArea.

B)Increasetheretentiontimeforthefiles.

C)Decreasetheretentiontimeforthefiles.

D)ManuallydeleteallthearchivedlogfilesfromtheFlashRecoveryAreabyusingoperatingsystem(OS)commands.

答案：AC

119.ViewtheExhibittoobservethemessagereceivedwhiletryingtodroptheSL_REPuserinOracleEnterpriseManager.TheSL_REPuserownsobjectsandiscurrentlyconnectedtothedatabaseinstance.

WhatwouldhappenifyouclickYESintheExhibit?

A)Anerrorisreturned,andtheuserisnotdropped.

B)Thedropoperationwaitsuntilthesessionstartedbytheuserends.

C)Theuserisdroppedsuccessfully,andthesessionstartedbytheuseriskilled.

D)Theuserisdropped,andtheobjectsownedbytheuseraretransferredtotherecyclebin.

答案：A

120.InthePRODdatabaseyouhavegrantedtheRESUMABLEsystemprivilegetotheCONNECTrole.Resumablespaceoperationhasbeenenabledforallusersessions.YouwantusersNOTtobeawareofanykindofspace-relatedproblemswhileperformingtransactions.Instead,youwanttheproblemtoberesolvedbyadatabasetriggerautomatically.Whichcombinationoftriggeringtimeandeventwouldyouusetoachievethisobjective?

A)AFTERCREATE

B)AFTERSUSPEND

C)BEFORECREATE

D)AFTERTRUNCATE

E)BEFORESUSPEND

F)AFTERINSERTORDELETEORUPDATE

G)BEFOREINSERTORDELETEORUPDATE

答案：B