Oracle 10g OCP 043 题库 1-40题 共185题

1.Youobservethatadatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason,youfindthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto,inordertodeterminethatrequiredsizeofthedatabasebuffercache?

A.MemoryAdvisor

B.SegmentAdvisor

C.SQLTuningAdvisor

D.SQLAccessAdvisor

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

Answer:A

AdequatephysicalmemoryhasasignificantimpactontheperformanceofyourOracleDatabase.Withitsautomaticmemorymanagementcapabilities,OracleDatabasecanautomaticallyadjustthememorydistributionamongthevariousSGAandPGAcomponentsforoptimalperformance.Theseadjustmentsaremadewithintheboundariesofthetotalamountofmemorythatyouallocatetothedatabase.

ADDMperiodicallyevaluatestheperformanceofyourdatabasetodetermineperformanceproblems.IfADDMfindsthatthecurrentamountofavailablememoryisinadequateandadverselyaffectingperformance,thenitcanrecommendthatyouincreasememoryallocations.YoucanselectnewmemoryallocationsusingtheMemoryAdvisors.

Additionally,youcanusetheMemoryAdvisorstoperformwhat-ifanalysisonthefollowing:

Thedatabaseperformancebenefitsofaddingphysicalmemorytoyourdatabase

Thedatabaseperformanceimpactofreducingthephysicalmemoryavailabletoyourdatabase

WiththeMemoryAdvisors,youcanobtainmemorysizingadviceasfollows:

Ifautomaticmemorymanagementisenabled,thenyoucangetadviceforsettingthetargetamountofmemorytoallocatetotheOracleinstance.

Ifautomaticmemorymanagementisdisabledandautomaticsharedmemorymanagementisenabled,thenyoucangetadviceonconfiguringthetargetsizesoftheSGAandinstancePGA.

Ifonlymanualsharedmemorymanagementisenabled,thenyoucangetadviceonsizingthesharedpool,buffercache,andinstancePGA.

http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/montune.htm#ADMQS1034

2.Exhibit

Inyourproductiondatabase,thetotalwaitsandthetimewaitedforlogfileparallelwritearesignificantlyhigh.Whileinvestigatingthereason,youfindthattherearethreeredologgroupswithtwomembersineachgroup,andallredologmembersareplacesonasinglephysicaldisk.Whatactionwouldyoutaketominimizethewaits?

A.Startthelogwriterslaveprocesses

B.Increasethenumberofredologfiles

C.Increasethesizeoftheredologbuffer.

D.Placetheredologfilesonthedifferentdisks.

E.Increasethenumberoflogwriterprocesses.

Answer:D

3.Oneofthetablespaceisread-onlyinyourdatabase.Thelossofallcontrolfileforcedyoutorecreatethecontrolfile.Whichoperationdoyouneedtoperformafterre-creatingthecontrolfileandopeningthedatabase?

A.Dropandre-createtheread-onlytablespaces

B.Renametheread-onlydatafiletotheircorrectfilenames.

C.Changethetablespacestatusfromread/writetoread-only.

D.Re-createtheread-onlytablespacebecauseitisautomaticallyremoved.

Answer:B

4.Youhavesetsomeoftheinitializationparametersas:

DB_BLOCK_SIZE=8KB

SGA_MAX_SIZE=2GB

SGA_TARGET=0

SHARED_POOL_SIZE=120MB

DB_CHCHE_SIZE=896MB

STREAM_POOL_SIZE=0

LARGE_POOL_SIZE=110MB

Whichtwostatementsarecorrect?(Choosetwo).

A.YoucannotsetavaluefortheDB_8K_CHCHE_SIZEparameter.

B.Ifyouincreasethesizeofthelargepoolto120MB,thenthememoryallocatedtothesharedpollwillbereducedto110MB.

C.IfthevalueforSGA_TARGETischangedto1GBandSHARED_POOL_SIZEis120MB,thenmemorycannotbetakenfromthesharedpool,evenifthesharedpoolhasfreespaceavailable.

D.Ifanapplicationattemptstoallocatemorethan120MBfromthesharedpoolandfreespaceisavailableinthebufferpool,thenthefreespacefromthebufferpoolisallocatedtothesharedpool.

Answer:AC

5.Youareperformingablockmediarecoveryonthetools01.dbfdatafileintheSALESdatabaseusingRMAN.Whichtwostatementsarecorrectinthisscenario?(Choosetwo.)

A.YoumustensurethattheSALESdatabaseismountedoropen.

B.Youmustrestoreabackupcontrolfiletoperformablockmediarecovery.

C.Youmusttakethetools01.dbfdatafileofflinebeforeyoustartablockmediarecovery.

D.YoumustputthedatabaseinNOARCHIVELOGmodetoperformablockmediarecovery.

E.Youcanperformonlyacompletemediarecoveryofindividualblocks,point-in-timerecoveryofindividualdatablocksisnotsupported.

Answer:A,E

6.Exhibit

Youexecutedthefollowingcommandtoperformabackupofthe

USERStablespace:

RMAN>BACKUPTABLESPACEUSERS;

Whichtypeofbackupwouldthiscommandperform?

A.backupset

B.imagecopy

C.incrementalbackup

D.None;theuserreceivesanerrorindicatingthatthebackuptypemustbespecified.

Answer:A

7.Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure?

Howwouldyourecoverthelostredologmember?

A.importthedatabasefromthelastexport

B.restoreallthemembersinthegroupfromthelastbackup

C.dropthelostmemberfromthedatabaseandthenaddanewmembertothegroup

D.restoreallthedatabasefilesfromthebackupandthenperformacompleterecovery

E.restoreallthedatabasefilesfromthebackupandthenperformanincompleterecovery

Answer:C

Redogroup里如果有多个成员，那么他们是冗余的。每个成员里的内容都一样，所以删除在添加一个即可。

8.YouareusingOracleDatabase10g.Whichstatementregardinganincompleterecoveryistrue?

A.Youdonotneedtorestoreallthedatafiles.

B.YoudonotneedtoopenthedatabasewiththeRESETLOGSoperation

C.YoudonotneedtoperformafullbackupaftertheRESETLOGSoperation.

D.Youdonotneedtorecoverallthedatafilestothesamesystemchangenumber(SCN).

Answer:C

9.Exhibit

ViewtheExhibitandexaminetheResourceManagersettingsforthegroupsatdifferentlevels.

Whichtwoeffectswouldbetheresultofthissetting?(Choosetwo.)

A.ThemembersofLOW_GROUPwouldgetmoreprioritythanthoseofOTHER_GROUPS.

B.ThemembersofSYS_GROUPwouldgetmostoftheCPUallocationatlevel1.

C.ThemembersofLOW_GROUPwouldgetmostoftheCPUallocationbecauseithasCPUallocationattwodifferentlevels.

D.ThemembersofLOW_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.

E.ThemembersofSYS_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.

Answer:A,B

10.Thecurrenttimezoneforoneoftheusersessionsissettothedatabaselocaltimezone.Foroneapplication,theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.

Whichtwosolutionscouldtheuserimplementtoachievethisobjective?(Choosetwo.)

A.usetheALTERSYSTEMcommandtochangethetimezone

B.usetheALTERSESSIONcommandtochangethetimezone

C.usetheALTERDATABASEcommandtochangethetimezone

D.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachine

E.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachine

Answer:B,D

11.YouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning,whilequeryingtheuser1.employeestable,youreceivethefollowingerrormessage:

01578:ORACLEdatablockcorrupted(file#5,block#51)

ORA-01110:datafile5:

'/u01/app/oracle/oradata/orcl/example01.dbf'

Youneedtorectifythecorruptionwhileensuringthefollowing:

Thedatafileshouldremainonline.

Themeantimetorecover(MTTR)shouldbeminimal.

Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.Whichoptionwouldyouchoose?

A.flashbackthecorruptedblocks

B.usetheDBMS_REPAIRpackage

C.usetheRMANTSPITRcommand

D.usetheRMANBLOCKRECOVERcommand

E.usetheRESTOREDATABASEandRECOVERDATABASEcommands

F.investigatethetimeatwhichthecorruptionoccurredandperformapoint-in-timerecovery

Answer:D

12.YouareworkingonanOracleDatabase10gdatabase.YouenabledtheFlashbackDatabasefeature.Whichtwostatementsregardingflashbacklogsaretrue?(Choosetwo.)

A.Flashbacklogsarenotarchived.

B.Flashbacklogsaremaintainedinredologfiles.

C.FlashbacklogsaremaintainedintheFlashRecoveryArea.

D.FlashbacklogsareusedtomaintainFlashbackDatabaserelatederrors.

E.FlashbacklogsneedtobeclearedmanuallyafteryoudisableFlashbackDatabase.

Answer:A,C

13.Youexecutedthefollowingquery:

SELECToperation,undo_sql,table_nameFROMflashback_transaction_query;

Whichstatementiscorrectregardingthequeryoutput?

A.Itwouldreturninformationregardingonlythelastcommittedtransaction.

B.Itwouldreturnonlytheactivetransactionsinalltheundosegmentsinthedatabase.

C.Itwouldreturnonlythecommittedtransactionsinalltheundosegmentsinthedatabase.

D.Itwouldreturnbothactiveandcommittedtransactionsinalltheundosegmentsinthedatabase.

E.Itwouldreturninformationregardingthetransactionsthatbeganandwerecommittedinthelast30minutes.

Answer:D

FLASHBACK_TRANSACTION_QUERYdisplaysinformationaboutallflashbacktransactionqueriesinthedatabase.Thedatabasemusthaveatleastminimalsupplementalloggingenabledtoavoidunpredictablebehavior.

http://download.oracle.com/docs/cd/E11882_01/server.112/e10820/statviews_5113.htm#REFRN29086

14.Considerthefollowingconfiguration:

/devices/D1isamemberofdiskgroupdgroupA.

/devices/D2isamemberofdiskgroupdgroupA.

/devices/D3isamemberofdiskgroupdgroupA.

Youplantoaddanewdisk,/devices/D4,tothediskgroupdgroupA.

Youexecutethefollowingcommand:

SQL>ALTERDISKGROUPdgroupAADDDISK'/devices/D*';

Whichtaskwouldbeaccomplishedbythecommand?

A.Thecommandaddsthenewdisk,D4,tothediskgroup.

B.Thecommandwouldresultinanerrorbecausetheisnodiskbythename"'/devices/D*'"

C.Thecommandwillbeignoredbecausedisksstartingwith"D"arealreadymembersofthediskgroup.

D.Thecommandwouldresultinanerrorbecausenowildcardcharacterscanbeusedinthediskname.

E.Thecommandfirstdetachesallthememberdisksstartingwith"D",andthereattachesthemincludingthenewdisk.

Answer:A

15.YouworkasadatabaseadministratoratCertkiller.com.Inyourproductiondatabasethereisajob,CALC_STAT,whichhasbeenscheduledtoruneveryFridayat5.00p.m.CALC_STATupdatestheoptimizerstatisticsfortheobjectsownedbytheAPPSschema.Youwantthetasktobegeneric,therebyallowinguserstomodifytheattributesofthetaskatruntimewithoutaffectingtheoriginaltask.

WhichcomponentofOracleSchedulermustyoudefinetoachievethis?

A.Window

B.Program

C.Jobclass

D.Windowgroup

Answer:B

16.ImmediatelyafteraddinganewdisktoorremovinganexistingdiskfromanAutomaticStorageManagement(ASM)instance,youfindthattheperformanceofthedatabasedecreasesinitially,untiltheadditionorremovalprocessiscompleted.

Performancethengraduallyreturnstonormallevels.Whichtwoactivitiescouldyouperformtomaintainaconsistentperformanceofthedatabasewhileaddingorremovingdisks?(Choosetwo.)

A.increasethenumberofcheckpointprocesses

B.definethePOWERoptionwhileaddingorremovingthedisks

C.increasethenumberofDBWRprocessesbysettingupahighervalueforDB_WRITER_PROCESSES

D.increasethenumberofslavedatabasewriterprocessesbysettingupahighervalueforDBWR_IO_SLAVES

E.increasethenumberofASMRebalanceprocessesbysettingupahighervalueforASM_POWER_LIMITduringthediskadditionorremoval

Answer:B,E

17.Thecurrenttimeis12:00noon.YouwanttorecovertheUSERStablespacefromafailurethatoccurredat11:50a.m.Youdiscoverthattheonlymemberofanunarchivedredologgroupcontaininginformationfrom11:40a.m.onwardsiscorrupt.

Withreferencetothisscenario,ifyouarenotusingRecoveryManager(RMAN),

whichrecoverymethodwouldyouuse?

A.time-basedrecovery

B.logsequencerecovery

C.cancel-basedrecovery

D.change-basedrecovery

Answer:C

18.YoulostthePRODSTDtablespace,whichwasread/write.Thetablespacewasread-onlywhenthelastbackupwasperformed.Howwouldyourecoverthetablespace?

A.restorethetablespacefromthebackup;thereisnoneedtoapplytheredoinformation

B.restorethefulldatabasetorecoverthedatauptothepointwhenyouperformedthebackup

C.restorethetablespacefromthebackupandthenperformarecoveryusingthebackupcontrolfile

D.restorethetablespacefromthebackupandthenrecoverthetablespace;alltheredoinformationfromthepointwhenthetablespacewasmaderead/writeisapplied

Answer:D

19.YouareusinganAutomaticStorageManagement(ASM)instancetomanagethefilesofyourproductiondatabase.Youhavetwodiskgroups,DG1andDG2withonedeviceeach.Intheparameterfileoftheproductiondatabase,thefollowingparametershavebeenspecified:

DB_CREATE_ONLINE_LOG_DEST_1='+dg1'

DB_CREATE_ONLINE_LOG_DEST_2='+dg2'

Whatwouldbetheimpactofthissetting?

A.Whenanewloggroupisadded,itwouldhaveonememberineachdiskgroup.

B.Whenanewloggroupisadded,itwouldhavetwomembersineachdiskgroup.

C.Whenanewtablespaceisadded,itwouldhaveonedatafileineachdiskgroup.

D.Whenanewlogfileisadded,itwouldhaveonememberspreadacrossthediskgroups.

Answer:A

20.AnRMANbackupjobfails,displayingthefollowingerror:

ORA-19809:limitexceededforrecoveryfiles

YouranalysisshowsthattheFlashRecoveryareaisfull.Whichtwoactionscouldyoutaketoresolvetheerrorandavoidthiserrorinthefuture?(Choosetwo.)

A.takethebackupoftheflashrecoveryarealessfrequently

B.increasethevalueoftheUNDO_RETENTIONinitializationparameter

C.changethevalueoftheWORKAREA_SIZE_POLICYinitializationparametertoAUTO

D.changethebackupretentionpolicytoretainthebackupsforasmallerperiodoftime

E.increasethevalueoftheDB_RECOVERY_FILE_DEST_SIZEinitializationparameter

F.increasethevalueoftheCONTROL_FILE_RECORD_KEEP_TIMEinitializationparameter

Answer:D,E

21.YourdatabaseoperatesinARCHIVELOGmode.User-managedconsistentbackupsareperformedeverySundaynight.

OnTuesday,clientAdropsatableat8:00a.m.asfollows:

SQL>DROPTABLEcust_ordPURGE;

Tabledropped.

ClientBexecutesaqueryat9:00a.m.onthesametableasfollows:

SQL>SELECT*FROMcust_ord;

SELECT*FROMcust_ord

*

ERRORatline1:

ORA-00942:tableorviewdoesnotexist

ClientBneedsthedroppedtableandreportstheproblemtoyou.

Withreferencetothisscenario,whichactionshouldyoutake?

A.retrievethetablebyusingtheflashbackfeature

B.restoreallthedatafilesfromlastSunday'sbackupandthenperformatime-basedrecovery

C.restoreallthedatafilesfromlastSunday'sbackupandthenperformalogsequencerecovery

D.restoreallthedatafilesfromlastSunday'sbackupandthenperformacancel-basedrecovery

E.restorefromlastSunday'sbackuponlydatafilesthatbelongtothetablespaceinwhichthetablewasstoredandthenperformacompleterecovery

Answer:B

22.YouperformedanincompleterecoveryonyourOracleDatabase10gdatabaseusingthefollowingcommand:

SQL>RECOVERDATABASE

2UNTILTIME'2004-08-05:12:10:03'

3USINGBACKUPCONTROLFILE;

Inwhichsituationwouldtheaboverecoveryberequired?

A.Ausertablewaslostatthespecifiedtime.

B.Aredologfilewaslostatthespecifiedtime.

C.Thebackupcontrolfileisonafasterdiskthanthecurrentone.

D.Thecurrentcontrolfilehasadifferentpathcomparedwiththeintendedtimeofrecovery.

E.Thecurrentcontrolfiledoesnotmatchthephysicalstructureofthedatabaseattheintendedtimeofrecovery.

Answer:E

23.WhilecreatingajobclassusingtheDBMS_SCHEDULERpackage,yousettheloggingleveltoLOGGING_RUNS.Whatwouldbetheimpactofthissetting?

A.OracleSchedulerwouldwritedetailedinformationtothejoblogforeachrunofeachjobinthejobclass.

B.OracleSchedulerwouldwritedetailedinformationtothejoblogforthefirstrunofeachjobinthejobclass.

C.OracleSchedulerwouldwritedetailedinformationtothejoblogforeachrunofonlythefirstjobinthejobclass.

D.OracleSchedulerwouldwritedetailedinformationforalloperationsperformedonalljobsinthejobclass.

Answer:A

Oracle10gScheduler特性

http://blog.****.net/tianlesoftware/archive/2009/10/23/4715218.aspx

24.YouaredesigninganapplicationforCertkiller.comandyouhavebeenaskedtodesignadatabasetabletofacilitatemonthlybillgeneration.Thebillwouldincludedetailsofcustomercalls,listedinchronologicalorder.

Whichmethodwouldyoufollowtoachievethisobjectivewithoutincreasingtheoverheadofsortingtherows?

A.createahashclustertostorethedata

B.createanindexclustertostorethedata

C.createapartitionedtabletostorethedata

D.createasortedhashclustertostorethedata

E.createaheaptablewithrowidtostorethedata

Answer:D

25.YousettherecoverywindowtosevendaysandthebackupoptimizationtoONusingtheCONFIGUREcommandofRecoveryManager(RMAN).ThemostrecentbackupoftheTOOLStablespacetodiskwastakenonJanuary3.TheTOOLStablespaceisread-only.OnFebruary21,whenyouexecuteacommandtobackupallthetablespacestodisk,youfindthatRMANbacksuptheTOOLStablespacealso,eventhoughthecontentsofthetablespacehavenotchangedafterthebackuponJanuary3.BecausetherearenochangesmadetotheTOOLStablespace,youdecidethatthetablespaceshouldnotbebackedupbyRMAN.WhatcanyoudotoskipbackinguptheTOOLStablespacewithoutchangingthecurrentbackupoptimizationsetting?

A.configureadefaultdeviceforRMANbackups

B.temporarilydisabletheretentionpolicyforRMANbackups

C.configureautomaticchannelallocationforRMANbackups

D.usetheCONFIGUREcommandtoreconfiguretherecoverywindowto60days

Answer:D

26.Exhibit:

YouwanttoconfiguretheFlashbackDatabasefeatureandretainflashbacklogsforthreedays.

Thestepsusedinthisprocessaredisplayedintheexhibit.

InwhatsequencewouldyouneedtoperformthesestepstoenabletheFlashbackDatabasefeature?

A.D,C,A,B,E

B.D,A,C,B,E

C.B,D,C,E,A

D.D,B,E,C,A

Answer:A

27.Inwhichscenarioswouldyourebuildanindex?(Chooseallthatapply.)

A.whenyouneedtodisabletheindexusage

B.whenyouneedtochangestorageoptions

C.whenyouneedtoenableindexmonitoring

D.whenyouneedtomovetheindextoanothertablespace

Answer:B,D

28.YouenabledAutomaticSharedMemoryManagement.Theinitializationparametersaresetasshownbelow:

SGA_TARGET=10GB

SGA_MAX_SIZE=14GB

STREAMS_POOL_SIZE=1GB

SHARED_POOL_SIZE=3GB

Whichtwostatementsarecorrectinthisscenario?(Choosetwo.)

A.Amaximumof3GBcanbeallocatedtosharedpool.

B.ThevalueforSGA_TARGETcanbeincreaseduptoamaximumof15GB.

C.Atotalof14GBmemorywillbeallocatedtotheautomaticallytunedmemorycomponents.

D.IncreasingthevalueforSGA_TARGETwillautomaticallyincreasethememoryallocatedforSTREAMS_POOL_SIZE.

E.IncreasingthevalueforSGA_TARGETto12GBwillautomaticallyincreasethememoryallocatedtoautotunedparameters.

F.ReducingthevalueforSGA_TARGETto9GBwillautomaticallydecreasethememoryallocatedtosharedpoolfrom3GBto2GB.

Answer:B,E

29.Whichstatementcorrectlydescribesthechangetrackingwriter(CTWR)backgroundprocess?

A.Itkeepstrackofchangesinthebackgroundprocesses.

B.Itrecordsthesystemchangenumber(SCN)inthecontrolfile.

C.Itwritesauditrecordsforuserchangestothechangetrackingfile.

D.Itrecordsanychangestothelistenedconfigurationinthelistener.orafile.

E.Itrecordsanychangestothedatabaseparametersinthechangetrackingfile.

F.Itrecordsthephysicallocationofallthechangesthataremadetothedatabaseinthechangetrackingfile.

Answer:F

Explanation:

ThisisanewprocessChangeTrackingWriter(CTWR)whichworkswiththenewblockchangedtrackingfeaturesin10gforfastRMANincrementalbackups.

ThisisaclarificationofthedocumentationforsizingtheBlockChangeTrackingFile.

BlockChangeTrackingisusedtooptimizeincrementalbackups.Anewfileisintroduced:

-ChangedblocksaretrackedbytheCTWRbackgroundprocessasredoisgenerated

-DatabasebackupsautomaticallyusethechangetrackingfileSizingofthisfileisimportant,andeventhoughyoucanuse

V$BLOCK_CHANGE_TRACKINGviewtomonitortheusage,itmayinsomecasesnotbeeasytochangethesize,iewhenusingrawdevices.

30.YouworkasadatabaseadministratoratCertkiller.com.Inyourproductiondatabase,youobservethatusers'transactionsareconsumingalotofresourceandyouplantoimposeresourcerestrictionsbyusingResourceManager.ForwhichthreeresourcescanyouenableusagerestrictionsbyusingResourceManager?(Choosethree.)

A.CPUusage

B.degreeofparallelism

C.numberofopencursors

D.numberofsortsperformed

E.idletimeforblockingsessions

F.numberofdiskI/Ooperationsperformed

G.numberofmemoryI/Ooperationsperformed

Answer:A,B,E

31.Youhavespecifiedthewarningandcriticalthresholdvaluesofanapplicationtablespacetobe60%and70%respectively.Fromthetablespacespaceusagemetrics,youfindthattheactualspaceusagehasreachedthespecifiedwarningthresholdvalue,butnoalertshavebeengenerated.Whatcouldbethereasonforthis?

A.TheEVENTparameterwasnotset.

B.TheSQL_TRACEparameterissettoFALSE.

C.TheEnterpriseManagerGridControlisnotused.

D.TheSTATISTICS_LEVELparameterissettoBASIC.

E.TheTIMED_STATISTICSparameterissettoFALSE.

Answer:D

32.YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourOracle10gdatabase:

RMAN>REPORTNEEDBACKUPdays3;

Whatwouldbetheoutputofthiscommand?

A.alistoffilesthatrequireabackupwithinthreedays

B.alistoffilesthathavenotbeenbackedupforthreedays

C.alistoffilesthatRMANrecommendsbebackeduponlyonceineverythreedays,basedonlowvolatility

D.alistoffilesforwhichabackuphasalreadybeenperformedandmayneedabackupafterthreedays

Answer:B

33.YourdatabaseoperatesinARCHIVELOGmode.Theredologfilesarenotmultiplexedandoneoftheonlineredologsismissing.Themissingredologsequence,230,isnotarchivedanditcontainedinformationfrom10:35a.m.onwards.Thecurrenttimeis11:00a.m.Becauseofadiskcrash,youexecutedthefollowingcommandtoperformanincompleterecovery:

RMAN>RUN{

2>SETUNTILSEQUENCE230THREAD1;

3>ALTERDATABASEMOUNT;

4>RESTOREDATABASE;

5>RECOVERDATABASE;

6>ALTERDATABASEOPENRESETLOGS;

7>};

Withreferencetothisscenario,whichstatementistrue?

A.RMANrecoversuptologsequence230,butnotincluding230.

B.RMANreturnsanerrorbecausethelogsequencenumbermentionedinthecommandshouldbe229.

C.RMANreturnsanerrorbecausethelogsequencenumbermentionedinthecommandmayneverbemissing.

D.RMANrecoversuptoandincludinglogsequence229butthenreturnsanerrorbecauselogsequence230ismissing.

Answer:A

34.Inyourdatabase,allthetablespacesarelocallymanaged.YoustartedRecoveryManager(RMAN)usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand:

RMAN>RESTORECONTROLFILE;

Whichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup?(Choosetwo.)

A.shutdownandrestarttheinstance

B.addnewtempfilestothetemporarytablespacesafterrecovery

C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption

D.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode

Answer:B,C

35.Whiledesigningyourdatabase,youhavecreatedtheEMPLOYEEStableasanindex-organized(IOT).YouwanttocreateabitmapindexontheJOD_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex?

A.Aprimarykeymusthavebeencreated.

B.Amappingtablemusthavebeencreated.

C.Anoverflowtablespacemusthavebeenspecified.

D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

Answer:B

36.Exhibit

OneoftheimportanttablesintheUSERStablespacewasdroppedandpurgedfromtherecyclebinat9:00a.m.Younoticedthis

at11:00a.m.andyouwanttoperformanincompleterecoverytorecoverthetable.Whichstatementistrue?

A.Youmustrecoveralldatafilestotherequiredsystemchangenumber(SCN).

B.Youmustrecoveralldatafiles,exceptthosethatareoffline,totherequiredSCN.

C.YoumustrecoveralldatafilesbelongingtotheUSERStablespacetotherequiredSCN.

D.Youcannotrecoveralldatafilesbecausesegmentspacemanagementisperformedmanuallyfortheundotablespace.

Answer:B

37.YouworkasadatabaseadministratoratCertkiller.com.YourproductiondatabaseusesanAutomaticStorageManagement(ASM)instancetomanageitsfiles.YouwanttoaddanewdiskgrouptotheASMinstancetomanagetheincreaseddataload.

WhatactionwouldyouperformtoincludethenewdiskgroupintheASMinstancewithoutcausinganyimpactonthecurrentlyconnectedusers?

A.mountthenewdiskgroupintheASMinstance

B.restarttheASMinstanceandtheproductiondatabaseinstance

C.registerthenewdiskgroupsintheproductiondatabaseinstance

D.restarttheASMinstancewithoutrestartingtheproductiondatabaseinstance

E.includethenewdiskgroupintheASM_DISKSTRINGparameterintheparameterfileandrestarttheASMinstance

Answer:A

38.TheDB_BLOCK_CHECKINGinitializationparameterissettoTRUE.Whatwouldbetheresultofthissettingonthedata

blocksbeingwrittentothedatafiles,everytimetheDBWnwrites?

A.TheOracledatabasewillcheckalldatablocksbygoingthroughthedataoneachblock,makingsurethedataisself-consistent.

B.TheDBWnandthedirectloaderwillcalculateachecksumandstoreitinthecacheheaderofeverydatablockwhenwritingittodisk.

C.TheOracledatabasewillcheckdatablocksbelongingtotheSYSTEMtablespaceonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.

D.TheOracledatabasewillcheckdatablocksbelongingtotheSYSAUXtablespaceonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.

E.TheOracledatabasewillcheckdatablocksintheSYSTEMandSYSAUXtablespacesonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.

Answer:A

39.InyourproductiondatabaseyouwanttouseanAutomaticStorageManagement(ASM)instancetomanagethedatabasefiles.Whichoptionwouldyouusetomigratethedatabasefilesfromanon-ASMinstancetoanASMinstance?

A.OracleMigrationAssistant

B.RecoveryManager(RMAN)

C.OracleDataPumpExportandImport

D.conventionalOracleExportandImport

E.operatingsystemutilitiestocopythefilestotheASMinstance

Answer:B

40.Intheparameterfileofyourproductiondatabase,theCONTROL_FILE_RECORD_KEEP_TIMEparameterissetto31.WhatwouldbetheimpactofthissettingonthebackupthatisbeingperformedbyusingRecoveryManager(RMAN)?

A.Thebackupwouldberetainedonthemediafor31days.

B.Thebackupwouldbemaintainedintherecoverycatalogfor31days.

C.Thebackupmetadatawouldberetainedinthecontrolfilefor31days.

D.Thebackupmetadatawouldbemaintainedintherecoverycatalogfor31days.

E.Automaticbackupsofthecontrolfilewillberetainedintheflashrecoveryareafor31days.

Answer:C

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

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