Oracle11GR2题库文档下载

Oracle11GR2题库类别数量说明

此是我根据053的676道分类的，并删除了重复部份，我已考完，仅供大家学习参考.QQ：994165

TYPESHRINK

ALTERTABLEbookingSHRINKSPACE—收高水位

COMPACT"只有他不会收高水位

Casecde—收高水位并且把相关index等一起收缩

Q1.

Examinethefollowingcommand:

SQL>ALTERTABLEbookingSHRINKSPACECOMPACT;

Whichactivityisperformedwhentheprecedingcommandisexecuted?

A.TheshrinkoperationtoucheseveryblockintheBOOKINGtable

B.Thehigh-watermark(HWM)fortheBOOKINGtableisshiftedfromitsoriginalposition

C.TheprogressoftheshrinkoperationissavedinthebitmapblocksoftheBOOKINGtable

D.Thedatamanipulationlanguage(DML)triggersontheBOOKINGtableareexecutedbecause

theshrinkoperationisinternallyhandledbytheINSERT/DELETEoperation

Answer:C

Q2.

YouexecutedthefollowingSQLstatementtoshrinktheEMPLOYEEStablesegmentstoredin

theEXAMPLEtablespace:

ALTERTABLEemployeesSHRINKSPACECASCADE;

Whichstatementiscorrectinthisscenario?

A.TheEMPLOYEEStablewillbechangedtoread-onlymodeduringtheshrinkoperation.

B.TheindexescreatedontheEMPLOYEEStablewillneedtoberebuiltaftertheshrink

operationisover.

C.Theshrinkbehaviorwillbecascadedtoalldependentsegmentsofthetablethatsupport

ashrinkoperation.

D.Datamanipulationlanguage(DML)operationswillnotbepossibleontheEMPLOYEEStable

duringtheCOMPACTIONphaseoftheshrinkoperation.

Answer:C

Q3.

Youhave100segmentsintheUSERStablespace.YourealizethattheUSERStablespaceis

runninglowonspace.

YoucanuseSegmentAdvisorto_____.

A.identifythesegmentsthatyoushouldshrink

B.modifythestorageparametersforthetablespace

C.automaticallyshrinkthesegmentswithunusedspace

D.checkthealertsgeneratedforthetablespacethatisrunninglowonspace

Answer:A

Q4.

WhichtwostatementsregardingtheFlashbackTablefeaturearecorrect?(Choosetwo.)

A.FlashbackTablecanbeperformedonsystemtables.

B.FlashbackTableoperationdoesnotshrinkthesegments.

C.FlashbackTableuseslogminingtoextractSQL_REDOandSQL_UNDOstatements.

D.FlashbackTableoperationacquiresexclusivedatamanipulationlanguage(DML)locks.

Answer:BD

Q5.

TheBOOKINGStablecontainsonlinebookinginformation.Whenabookingisconfirmed,the

detailsaretransferredtoanarchivaltableBOOKINGS_HISTanddeletedfromtheBOOKINGS

table.Thereisnofixedtimeintervalbetweeneachonlinebookinganditsconfirmation.

Becausesufficientspaceisnotalwaysavailablefromthedeleteoperationsthe

high-watermark(HWM)ismovedupandmanyrowsareinsertedbelowtheHWMofthetable.

TheBOOKINGStablehasAutomaticSegmentSpaceManagement(ASSM)androwmovcmontonablod.

Thetableisaccessiblein24x7mode.

Whatisthemostefficientmethodtoreclaimthespacereleasedbythedeleteoperations

intheBOOKINGStable

A.PerformEXPORT,DROP,andIMPORToperationsontheBOOKINGStablesequentially

B.ShrinktheBOOKINGStablebyusingtheALTERTABLE…SHRINKSPACEcommand

C.MovetheBOOKINGStabletoadifferentlocationbyusingtheALTERTABLE...MOVEcommand

D.DeallocatethespaceintheBOOKINGStablebyusingtheALTERTABLE...DEALLOCATEUNUSED

command

Answer:B

Q6.

Younoticethatalong-runningtransactionissuspendedduetoaspaceconstraint,andthere

isnoAFTERSUSPENDtriggeredeventaddressingtheissue.Youalsonotethatthecritical

transactionisjustabouttoreachtheRESUMABLETIMEOUTvalue.Whichoftheseactionsis

appropriate?

A.Abortthesession,fixthespaceproblem,thenresubmitthetransaction.

B.UsetheDBMSRESUMABLE.SETSESSIONTIMEOUTproceduretoextendthetime-outforthe

sessionwhileyoufixtheproblem.

C.Donothing,letthetransactionfail,thenfixtheproblem.

D.UseSegmentShrinktocleanupthetable.

E.UsetheDBMSRESUMABLE.SETTIMEOUTproceduretoextendthetime-outforthesessionwhile

youfixtheproblem.

Answer:B

Q7.

ForwhichofthefollowingcanyouusoSegmentShrink?(Chooseallthatapply.)

A.Heaptables

B.Tableswithfunction-basedindexes

C.Indexes

D.Partitionsandsubpartitions

E.Noneoftheabove

Answer:ACD

Q8.

ViewtheexhibitandexaminetheTRAXStable'sstorageinfoneation.Afteramassivedelete

operation,youexecutedthefollowingstatementtoshrinktheTRANStable:SQL>ALTERTABLE

transSHRINKSPACECASCADE;Whichstatementdescribestheoutcomeofthecommand?

A.Anerrorisproduced.

B.Thetableandallrelatedobjectsarecompactedandthepositionofthehigh-watermark

(HWM)forthetableisadjusted

C.Thetableandrelatedindexesarecompactedbutthepositionofthehigh-watermark(HWM)

forthetableremainsunchanged

D.Theunusedspaceinthetableisreclaimedandreturnedtothetablespaceandthedata

manipulationlanguage(DML)triggersonthetablearefiredduringtheshrinkingprocess

Answer:B

Q9.

YouissuedthefollowingcommandonthetemporarytablespaceLMTEMPinyourdatabase:

SQL>ALTERTABLESPACEImtempSHRINKSPACEKEEP20M;

Whichrequirementmustbefulfilledforthiscommandtosucceed?

A.Thetablespacemustbelocallymanaged.

B.Thetablespacemusthaveonlyonetempfile.

C.Thetablespacemustbemadenondefaultandoffline.

D.Thetablespacecanremainasthedefaultbutmusthavenoactivesortoperations.

Answer:A

Q10.

WhichofthefollowingoptionsdescribesSegmentShrink?

A.Reclaimsspaceaboveandbelowthehigh-watermarkwithoutusingadditionalspace

B.Movesrowstoanewphysicallocation,resettingthehigh-watermark,butusesadditional

spaceduringtheoperation

C.Deallocatesspaceabovethehigh-watermarkthatiscurrentlynotinuse

D.Noneoftheabove

Answer:A

Qll.

Whenshrinkingatablesegment,youchoosetoshrinkalltheindexesforthattableusing

theSHRINKSPACEcommand.Whichclauseshouldyouuse?

A.INCLUDINGDEPENDENCIES

B.INCLUDINGDEPENDENCIESCASCADE

C.COMPACT

D.CASCADE

E.Noneoftheabove

Answer:D

redologmiss

Q12.

Whicharethecorrectsteps,inorder,todealwiththelossofanonlineredologifthe

databasehasnotyetcrashed?

A.Issueacheckpoint.

B.Shutdownthedatabase.

C.Issueanalterdatabaseopencommandtoopenthedatabase.

D.Startupmountthedatabase.

E.Issueanalterdatabaseclearlogfilecommand.

F.Recoveralldatabasedatafiles.

A.a,b,c,d

B.b,d,e,c

C.a,b,d,e,c

D.b,f,d,f,c

E.b,d,a,c

Answer:C

Q13.

Youhave10stallyouronlineredo10gs.Asaresult,yourdatabasehascrashed.Youhave

triedtorestartthedatabaseandcleartheonlineredologfiles,butwhenyoutrytoopen

thedatabaseyougetthefollowingerror.

SQL>startupORACLEinstancestarted.

TotalSystemGlobalArea167395328bytesFixedSizel298612bytesVariableSize142610252

bytes

DatabaseBuffers20971520bytesRedoBuffers2514944bytesDatabase

mounted.

0RA-00313:openfailedformembersofloggroup2ofthread1

0RA-00312:onlinelog2thread1:a/oracle01/oradata/orcl/redo02a.log

ORA-27037:unabletoobtainfilestatusLinuxError:2:Nosuchfileordirectory

Additionalinformation:3

0RA-00312:onlinelog2thread1:u/orac1eO1/oradata/orc1/redo02.logORA-27037:unable

toobtainfile

statusLinuxError:2:NosuchfileordirectoryAddfitionalinformation:3

SQL>alterdatabaseclearlogfilegroup2;alterdatabaseclearlogfilegroup2*ERROR

atline1:

ORA-01624:log2neededforcrashrecoveryofinstanceorcl(thread1)ORA-00312:online

log2thread

1:"/orac1eO1/oradata/orc1/redo02.1ogORA-00312:onlinelog2thread1:

a/oracle01/oradata/orcl/redo02a.log

Whatstepsmustyoutaketoresolvetheerror?

A.Issuetherecoverdatabaseredologscommand.

B.IssuetheStartupMountcommandtomountthedatabase.

C.Restorethelastfulldatabasebackup.

D.Performapoint-in-timerecovery,applyingallarchivedredologsthatareavailable.

E.Restoreallarchivedredo10gsgeneratedduringandafterthelastfulldatabasebackup.

F.Openthedatabaseusingthealterdatabaseopenresetlogscommand.

G.Issuethealterdatabaseopencommand.

A.b,a,f

B.e,b,a,f

C.e,b,a,g

D.b,a,g

E.c,e,b,d,f

Answer:E

Q14.

Ifalogfilebecomescorrupted,itmaycausethedatabasetostall.Howwouldyoucorrect

suchasituation?

A.Recovertheonlineredologfrombackup.

B.Deleteandre-createthelogfile.

C.Usethealterdatabaseclearlogfilecommandtoclearthelogfile.

D.Shutdownthedatabaseandrestartit.

E.Shutdownthedatabaseandthenmountit.Clearthelogfilewiththealterdatabase

clearlogfilecommandandthenrestartthedatabasewithalterdatabaseopenresetlogs.

Answer:C

Q15.

YourdatabaseisinARCHIVELOGmode.Youhavetwoonlineredologgroups,eachofwhich

containsoneredomember.Whenyouattempttostartthedatabase,youreceivethefollowing

errors:

ORA-00313:openfailedformembersofloggroup1ofthread1

ORA-00312:onlinelog1thread1:'D:\REDOO1.LOG'

Youdiscoverthattheonlineredologfileofthecurrentredogroupiscorrupted.

Whichstatementshouldyouusetoresolvethisissue?

A.ALTERDATABASEDROPLOGFILEGROUP1;

B.ALTERDATABASECLEARLOGFILEGROUP1;

C.ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP1;

D.ALTERDATABASEDROPLOGFILEMEMBER'D:\REDOOLLOG';

Answer:C

Q16.

AdatabaseisrunningInARCHIVEmode.Ithastwoonlineredologgroupsandeachgroup

hasonemember.

ALGWRInput/output(I/O)fellsduetopermanentmediafailurethathasresultedInthe

lossofredologfileandtheLWGRterminatescausingtheinstancetocrash.Thestepsto

recoverfromthelossofacurrentredologgroupmemberintherandomorderareasfollow.

1)Restorethecorruptedredologgroup.

2)Restorefromawholedatabasebackup.

3)Performincompleterecovery.

4)Relocatebyrenamingthememberofthedamagedonlineredologgrouptoanewlocation.

5)OpenthedatabasewiththeRESETLOGSoption.

6)Restartthedatabaseinstance.

7)Issueacheckpointandclearthelog.

Identifytheoptionwiththecorrectsequentialstepstoaccomplishthetaskefficiently.

A.1,3,4,and5

clearthelog,incompleterecovery,relocatenewlocation,RESETLOGS

B.7,3,4.and5

C.2,3,4,and5

D.7,4,3.and5

E.Only6isrequired

Answer:B

Compressbackup[compress](10)

Q17.

Whatistheimpact.ofthefollowingbackupifitexceedsthedurationallowance?(Choose

allthatapply.)

Backupascompressedbackupsetduration2:00partialminimizeloaddatabase;

A.Theentirebackupwillfail.Itwillnotbeusableforrecovery.

B.Theentirebackupwillfail,butanydatafilesuccessfullybackedupwillbeusablefor

recovery.

C.Ifthisbackupfails,subsequentbackupswillprioritizedatafilesnotbackedup.

D.Ifthisbackupfails,anerrorwillberaisedandanyothercommandswillnotbeexecuted.

E.Ifthisbackupfails,noerrorwillberaisedandanyothercommandswillbeexecuted.

Answer:B

Q18.

Compressedbackupsworkwithwhichofthefollowingcommands?

A.copyasbackup

B.backupascopy

C.backup

D.copy

Answer:C

Q19.

WhichcommandisusedtoconfigureRMANtoperformacompressedbackupforeverybackup

executed?

A.BACKUPASCOMPRESSEDBACKUPSETDATABASE

B.BACKUPASCOMPRESSEDCOPYOFDATABASE

C.CONFIGUREDEVICETYPEDISKBACKUPTYPETOCOMPRESSEDBACKUPSET

D.CONFIGUREDEVICETYPEDISKBACKUPTYPECOMPRESS

E.BACKUPDATABASECOMPRESS

Answer:C

Q20.

Howlongwillthisbackupbeallowedtorun?

Backupascompressedbackupsetduration2:00minimizeloaddatabase;

A.2minutes

B.2hours

C.2days

D.Thecommandwillgenerateanerror.

E.Thisbackupisnotconstrainedbyanytimelimitation.

Answer:B

Q21.

YouareusingRecoveryManager(RMAN)toperformbackups.Inwhichthreesituationswould

youperformacompressedbackup?(Choosethree.)

A.Youarebackinguptotapeandyourtapedeviceperformsitsowncompression.

B.Youaremakingimagecopies,andyouhavenotenabledtablespacecompression.

C.Youareusingdisk-basedbackupsanddiskspaceisyourFlashRecoveryArea,orother

disk-basedbackupdestinationsarelimited.

D.Youareperformingyourbackupstosomedeviceoveranetworkwherereducednetwork

bandwidthismoreimportantthanCPUusage.

E.Youareusingsomearchivalbackupmedia,suchasCDorDVD,wherereducingbackupsizes

savesmediacostsandarchivalstorage.

Answer:CDE

Q22.

YouperformabackupusingthefollowingBACKUPcommand:

RMAN>BACKUPASCOMPRESSEDBACKUPSETDATABASE;

Whichstatementistrueofthiscommand?

A.Adifferentprocedureisrequiredtorestoreadatabasefromcompressedbackups

B.TheASCOMPRESSEDclauseoftheBACKUPcommandprovidedbyRMANisusedtocreate

compressedbackupsetsandimagecopies.

C.Usingthiscommandtocreatebackupsminimizesthebandwidthconsumed

D.Usingthiscommandtocreatebackupsimprovestheperformanceofthebackupprocess

Answer:C

Q23.

Ashoot-outhaseruptedbetweenyourMSdevelopmentteamsusing.NETandyourLinux

developmentteamsusingJava.Knowingthatyourdatabaseisindanger,whichcommandwould

youusetobackupyourNOARCHIVELOGmodedatabaseusingRMANwithcompression?

A.backupdatabaseall

B.backupcompresseddatabase

C.backupascompressedbackupsetdatabase;

D.backupascompressedbackupdatabaseplusarchivelogall;

E.backupascompressedbackupsetdatabasepluscompressarchivelogall;

Answer:C

Q24.

YouwanttouseRMANtocreatecompressedbackups.

WhichstatementistrueaboutthecompressionalgorithmsthatRMANcanuse?

A.TheBZIT2compressionalgorithmconsumesmoreCPUresourcesthantheZLIBcompression

algorithm.

B.TheZLIBcompressionalgorithmconsumesmoreCPUresourcesthantheBZIP2compression

algorithm.

C.TheZLIBcompressionalgorithmprovidesmaximumcompressionandproducessmallerbackups

thantheBZIP2compressionalgorithm.

D.OnlytheBZIP2compressionalgorithmcanbeusedtomakecompressedbackupstodisk.

Answer:A

Q25.

Youwanttobackupyour100-GBdatabaseonaremotetapedevice.Youarerequiredtoensure

thatminimumnetworkbandwidthisconsumedwhiletransferringthebackupstothetape

device.

ThecurrentconsumptionofyourCPUisapproximately40percent.

Whichtypeofbackupshouldyouperform?

A.standardbackupset

B.imagecopy

C.compressedbackup

D.user-managedbackup

Answer:C

RMANduplication(10)

Q26.

YouaremanagingtheAPPPRODdatabaseasaDBAwhichisnotusingtheOracle-managedfiles.

YouplantoduplicatethisdatabaseinthesamesystemwiththenameDUPDB.Youwanttocreate

thesamedirectorystructureforduplicatedatabasefilesasofthetargetdatabase.

YouexecutedthefollowingRMANcommands:

RMAN>CONNECTTARGETsys/sys@APPPROD

RMAN>CONNECTAUXILIARYsys/sys@DUPDB

RMAN>DUPLICATETARGETDATABASETOdupdbFROMACTIVEDATABASE

PASSWORDFILESPILENOFILENAMECHECK;

Whataretheimplicationsofthiscommand?

A.ItcreatesdatabasefilesfortheduplicatedatabaseundertheOraclebasewitha

differentdirectoryfortheduplicatedatabase.

B.Itoverwritesdatafilesofthetargetdatabasebecauseadifferentlocationfordata

filesisnotmentionedfortheduplicatedatabase.

C.ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthat

ofthetargetdatabasewiththesamedirectorystructure.

D.ItcreatesdatabasefilesfortheduplicatedatabaseunderthesameOraclehomeasthat

ofthetargetbutwithadifferentdirectoryfortheduplicatedatabase.

Answer:B

Q27.

Whenyoureperformingactivedatabaseduplication,abackupofwhatkindisrequired?

A.AcurrentRMANbackup-setbackupisrequired.

B.\obackupisrequired.

C.AnRMANimagebackupisrequired.

D.Amanualbackupisrequired.

E.A"duplicate〃preparatorybackupisrequired.

Answer:B

Q28.

YouaremanaginganOracleDatabase11ginstance.Youwanttocreateaduplicatedatabase

fortestingpurpose.

Whataretheprerequisitesforperformingtheactivedatabaseduplication?(Chooseallthat

apply.)

A.Thesourcedatabasebackupmustbecopiedoverthenetfortestdatabase.

B.ThesourcedatabasemustberuninARCHIVELOGmodeifthedatabaseisopen.

C.Thesourcedatabasemustbeshutdowncleanlyifthedatabaseisinmountedstate.

D.Anetserviceniceshouldbesetupandalistenerconfiguredwiththetargetaswell

asthesourcedatabase.

Answer:BCD

Q29.

Examinethefollowingcommandthatisusedtoduplicateadatabaseonthesamehost:

RMAN>RUN

!

ALLOCATEAUXILIARYCHANNEL,aux1DEVICETYPEDISK;

DUPLICATETARGETDATABASETOauxdbSKIPREADONLY;\}

Whichtwostatementsdescribetheeffectafterthedatabaseisduplicatedsuccessfully?

(Choosetwo)

A.Thedatafilesoftheread-onlytablespacesinthetargetdatabasearenotduplicated

B.Theread-onlytablespacesinthetargetdatabasearestilldefinedinnewthedatabase

C.Theread-onlytablespacesinthetargetdatabasearechangedtoonlineafterduplication

D.Thedatafilesoftheread-onlytablespacesinthetargetdatabasegetduplicated

E.Theread-onlytablespacesinthetargetdatabasearenotdefinedinthenewdatabase

Answer:AB

Q30.

Whatarethetwodifferenllypesofdatabaseduplication?(Choosetwo.)

A.Active

B.Passive

C.Online

D.Backup-based

E.Failuredriven

Answer:AD

Q31.

Whichoperationrequiresthatyoucreateanauxiliaryinstancemanuallybeforeexecuting

theoperation?

(Chooseallthatapply.)

A.Backupbaseddatabaseduplication.

B.Activedatabaseduplication.

C.Tablespacepoint-in-timerecovery.

D.Nooperationrequiresthecreationofanauxiliaryinstance.

Answer:AB

Q32.

WhyshouldyoubackupaduplicatedtablespaceafteraTSPITRiscomplete?

A.Thetablespacecannotbeduplicatedorrestoredtoanypointintimeafterthe

duplication.

B.Thetablespacecannotbeduplicatedorrestoredtothepointintimebeforethe

duplication.

C.TheentiredatabasecannotberestoredafteraTSPITR,soabackupisrequired.

D.Youcannotbringthetablespaceonlineuntilitsbeenbackedup.

E.Thereisnorequirementtodoso,asRMANwillbackupthetablespaceaftertheTSPITR.

Answer:B

Q33.

WhichofthefollowingcommandswillperformanactivedatabaseduplicationoftheORCL

databasetotheORCL2database?

A.Setoracle_sid=orcl

rmantarget=sys/robertauxname=sys/Robert@orcl2

ae-du甲工i-cate-1argetdatabasetoneworclfromactivedatabasenofilenamecheckspfile

setcontrol_files*c:\oracle\oradata\neworcl\control01.ctT,

'c:\oracle\oradata\neworcl\control02.ctl'

setdb_file_name_convert'c:\oracle\oradata\orcl，,?c:\oracle\oradata\neworcl'

set1og_fi1e_name_convert*c:\oracle\oradata\orcr,Jc:\oracle\oradata\neworcr;

B.Setoracle_sid=orcl

rmantarget=sys/robertauxname=sys/Robert@orcl2

duplicatetargetdatabasenofilenamecheck

spfilesetcontrol_files

'c:\oracle\oradata\neworcl\control01.ctT,'c:\oracle\oradata\neworcl\control02.ctT

setdb_filename_convert

'c:\oracle\oradata\orcr,，c:\oracle\oradata\neworcl'setlog_file_name_convert

'c:\oracle\oradata\orcl，,Jc:\oracle\oradata\neworcl’;

C.Setoracle_sid=orcl

rmantarget=sys/robertauxname=sys/Robert@orcl2

duplicatetargetdatabasetoneworclnofilenamecheck

spf-Lle©OFU-FOL二'c:\oracle\oradata\neworcl\control01.ctT,

'c:\orac1e\oradata\neworc1\contro102.ctl'

setdb_file_name_convert'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl'set

log_file_name_convert'c:\oracle\oradata\orcr,*c:\oracle\oradata\neworcl';

D.Setoracle_sid=orcl

rmantarget=sys/robertauxname=sys/Robert

duplicatetargetdatabasetoneworclfromactivedatabasenofilenamecheckspfileset

control_files'c:\oracle\oradata\neworcl\control01.ctT,

'c:\orac1e\oradata\neworcl\control02.ctl'

setdb_file_name_convert'c:\oracle\oradata\orcr,*c:\oracle\oradata\neworcl'

setlogfilenameconvertJc:\oracle\oradata\orcr,?c:\oracle\oradata\neworcl，;

E.Setoracle_sid=orcl

rmantarget=sys/robertauxname=sys/Robert@orcl2

duplicatetargetdatabasetoneworclfromactivedatabasenofilenamecheckspfileset

control_files'c:\oracle\oradata\neworcl\control01.ctT,

'c:\oracle\oradata\neworcl\control02.ctl'

setdbfilenameconvert'c:\oracle\oradata\orcr,,c:\oracle\oradata\neworcl，set

1og_fi1e_name_convert'c:\oracle\oradata\orcr,*c:\oracle\oradata\neworcr;

Answer:E

Q34.

Howmanydatabaseinstancesareusedduringadatabase-duplicationprocess?

A.One

B.Two

C.Three

D.Four

E.Five

Answer:B

Q35.

Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyouset

toensurethattheonlineredologsarecreatedinthecorrectlocation?

A.logfile_name_convert

B.convert_log_file_name

C.filenameconvert_log

D.redo_log_file_name_convert

E.logfile_convert_directory

Answer:A

Q36.

Trueorfalse:youcanperformanactivedatabaseduplicationwhenthedatabaseisin

NOARCHIVELOG

mode.

A.True

B.False

Answer:B

TYPEASM_DISKGROUP58

Q37.

YouwanttoperformthefollowingoperationsfortheDATAASMdiskgroup:

-Verify_theconsistencyofthedisk.

-Cross-checkallthefileextentmapsandallocationtablesforconsistency,checkwhether

thealias

metadatadirectoryandfiledirectoryarelinkedcorrectly.

一CheckthatASMmetadatadirectoriesdonothaveunreachableallocatedblocks.

Whichcommandaccomplishesthesetasks?

A.ALTERDISKGROUPdataCHECK;

B.ALTERDISKGROUPdataCHECKDISK;

C.ALTERDISKGROUPdataCHECKFILE;

D.ALTERDISKGROUPdataCHECKDISKINFAILUREGROUP1;

Answer:A

Q38.

AdatabaseinstanceisusinganAutomaticStorageManagement(ASM)instance,whichhasa

diskgroup,DGROUP1,createdasfollows:

SQL>CREATEDISKGROUPdgrouplNORMALREDUNDANCY

FAILGROUPcontrollerlDISK'/devices/diskal',*/devices/diska2，FAILGROUPcontroller2

DISK,/devices/diskbr,?/devices/diskb2，;

WhathappenswhenthewholeCONTROLLER!Failuregroupisdamaged?

A.Thetransactionsthatusethediskgroupwillhalt.

B.ThemirroringofallocationunitsoccurswithintheC0NTR0LLER2failuregroup.

C.ThedataintheCONTROLLER1failuregroupisshiftedtotheCONTROLLER?failuregroup

andimplicitrebalancingistriggered.

D.TheASMdoesnotmirroranydataandnewlyallocatedprimaryallocationunits(AU)are

storedintheCONTROLLER2failuregroup.

Answer:C

Q39.

WhatistheadvantageofsettingtheASM-preferredmirrorreadfortheStretchcluster

configuration?

A.Itimprovesresyncoperations.

B.Thisfeatureenablesmuchfasterfileopens.

C.Itimprovesperformanceasfewerextentpointersareneededinthesharedpool.

D.Itimprovesperformancebyreadingfromacopyofanextentclosesttothenode.

Answer:D

Q40.

Examinethefollowingcommand:

ALTERDISKGROUPdataMOUNTFORCE;

Inwhichscenariocanyouusetheabovecommandtomountthediskgroup?

A.whenASMdiskgoesoffline

B.whenoneormoreASMfilesaredropped

C.whensomedisksinadiskgroupareoffline

D.whensomedisksinafailuregroupforadiskgrouparerebalancing

Answer:C

Q41.

InwhichsituationswilltheASMmetadatabackuphelpyourecovertheASMdiskinadisk

group?(Chooseallthatapply.)

A.whenoneormorefiledirectorypathsareaccidentallydeletedfromanASMdiskgroup

B.whenoneofthedisksinadiskgroupisaccidentalyunplugged

C.whenthedatafileonanASMdiskgroupgetscorrupted

D.whenoneormoredisksinanASMdiskgrouparelost

Answer:AD

Q42.

YouaremanaginganOracleDatabase11gASMinstancehavingthreedisksinadiskgroup

withASMcompatibilityattributesetto11.1.0andredundancysettohigh.Oneofthedisks

inthediskgroupbecomesunavailablebecauseofpowerfailure.Whichstatementswillbe

trueinthisscena