Oracle 10g OCP 043 题库 41-90题 共185题

41.Youdecidedtochangethelocationoftheflashrecoveryarea.Youexecutedthefollowingcommand:

ALTERSYSTEMSETDB_RECOVERY_FILE_DEST='+disk1'SCOPE=BOTHSID='*';

Whichstatementistrue?

A.Thelocationcanbechangedonlyiftheflashrecoveryareaisempty.

B.Afterexecutingthecommand,allnewflashrecoveryareafileswillbecreatedinthenewlocation.

C.Thecommandwillgenerateanerrorbecauseyoucannotchangetheflashrecoveryareawhilethedatabaseisopen.

D.AlltheexistingfilesintheflashrecoveryareawillbemovedtothenewlocationandallnewFlashRecoveryAreafileswillbecreatedinthenewlocation.

Answer:B

42.Exhibit

AuserhasinsertedwrongdepartmentdataintheDEPT3tableintheUSERStablespace.YouusetheFlashbackTablefunctionalitytorectifytheerroneousinserts.Whileperformingtherecovery,youchoose2004343astheFlashbackSCN.

Whichtwostatementsarecorrectinthisscenario?(Choosetwo.)

A.OnlytherowwithDEPARTMENT_ID290wouldbeflashedback.

B.TherowswithDEPARTMENT_ID290and300wouldbeflashedback.

C.TherowswithDEPARTMENT_ID290and280wouldbeflashedback.

D.YouwouldhavetakentheUSERStablespaceofflinebeforestartingtheFlashbackTableoperation.

E.YouwouldhaveenabledrowmovementfortheDEPT3tablebeforestartingtheFlashbackTableoperation.

Answer:B,E

43.UsingOracleScheduleryouhavescheduledtwojobs,JOB_AandJOB_B,torunat9:00p.m.everyFriday.Youwantboththejobstouseasingleresourceplan,WEEKEND_PLAN.Whichtaskmusthavealreadybeenperformedtoenableyoutoachievethisobjective?

A.AwindowmusthavebeencreatedwiththeWEEKEND_PLANresourceplan.

B.AprogrammusthavebeencreatedwiththeWEEKEND_PLANresourceplan.

C.AjobclassmusthavebeencreatedwiththeWEEKEND_PLANresourceplan.

D.AwindowgroupmusthavebeencreatedwiththeWEEKEND_PLANresourceplan.

Answer:C

Oracle10gScheduler特性

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

44.YourdatabaseisrunningontheautomaticProgramGlobalArea(PGA)memorymanagementandSharedMemoryManagementmode.YouwanttoincreasethememoryavailablefortheSQLworkareas.Whatwouldyoudo?

A.modifytheHASH_AREA_SIZEinitializationparameter

B.modifythePGA_AGGREGATE_TARGETinitializationparameter

C.modifytheWORK_AREASIZE_POLICYinitializationparameter

D.increasethevalueoftheSGA_TARGETinitializationparameter

E.increasethevalueoftheSGA_MAX_SIZEinitializationparameter

F.increasethevalueoftheSORT_AREA_SIZEinitializationparameter

Answer:B

45.OnTuesday,ajuniorDBAdroppedanimportantapplicationuseraccount,whoseschemahasimportanttables.Youareaskedtorecoveralltheobjectsintheschema.Oninvestigation,youfindthattheuseraccountwasdroppedat11:00a.m.and

Sunday'sbackupisthemostrecentbackup.Whichflashbackfeaturewouldyouuse?

A.FlashbackDrop

B.FlashbackTable

C.FlashbackDatabase

D.FlashbackVersionQuery

E.FlashbackTransactionQuery

Answer:C

46.Aredologfileiscorruptedwhilethedatabaseisopen;asaconsequence,databaseoperationsarestoppedbecausearchivingcannotcontinue.Whatwouldyoudotosolvetheproblem?

A.cleartheredologgroup

B.performredologfileimport

C.performanincompleterecovery

D.performaredologrecoveryusingRecoveryManager(RMAN)

E.shutdownthedatabaseandopenthedatabaseintheNOARCHIVELOGmode

Answer:A

47.YouareworkingonanOracleDatabase10gdatabase.Becauseofdataloss,youdecidedtoperformaFlashbackDatabaseoperationusingthefollowingcommand:

SQL>FLASHBACKDATABASETOTIMESTAMP(SYSDATE?5/24);

Whichtwostatementsaretrue?(Choosetwo.)

A.SYSDATEshouldnotbeusedwithTIMESTAMP.

B.Thedatabasemusthavemultiplexedredologfiles.

C.ThedatabasemustbeintheMOUNTstatetoexecutethecommand.

D.ThedatabasemustbeopenedwiththeRESETLOGSoptionaftertheflashbackoperation.

E.Theentiredatabaseneedstoberestoredfromthemostrecentbackupbeforetheflashbackoperation.

Answer:C,D

ThedatabasemustbemountedinexclusivemodetoissuetheFLASHBACKDATABASEcommandandmustbeopenedwiththeRESETLOGSoptionwhenfinished.

48.YouworkasadatabaseadministratoratCertkiller.com.Inyourtestdatabase,youfindthatauser'ssessionisexecutingalotofSQLstatements,resultinginthegenerationofalargenumberoftracefiles.Whileinvestigatingthereason,youfindthatSQLtracehasbeenenabledattheinstancelevel.YouwanttodisableSQLtrace,remotely,onlyforthatusersessiontoreducethevolumeoftracedatabeinggenerated.Howdoyouachievethisobjective?

A.bysettingtheSQL_TRACEparametertoFALSEintheparameterfile

B.byusingDBMS_MONITOR.SESSION_TRACE_DISABLEtodisablethetracingfortheusersession

C.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSYSTEMcommandintheusersession

D.bysettingtheSQL_TRACEparametertoFALSEbyusingtheALTERSESSIONcommandintheusersession

Answer:B

49.Youexecutethefollowingcommandtoenableasessioninresumablemode:

SQL>ALTERSESSIONENABLERESUMABLETIMEOUT60;

Whatistheimpactofatimeoutonthestatementsbeingsuspended?

A.Thestatementsremainsuspendedforatleast60seconds.

B.Thestatementsaresuspendedfor60secondsandthentheyareexecuted.

C.Thesuspendedstatementserroroutiftheproblemisnotrectifiedwithin60seconds.

D.Thestatementsareautomaticallysuspended60secondsafteranerrorisreceived,andthenattempttoexecutenormallyagain.

Answer:C

50.YouaremanaginganOracleDatabase10gdatabasethatusesOracleManagedFiles(OMF).Youenabledtheblockchangetrackingfeatureforthedatabase.Whichstatementregardingthechangetrackingfileistrue?

A.Oneblockchangetrackingfileiscreatedforeachdatafile.Bydefault,thefileiscreatedinDB_CREATE_FILE_DEST.

B.Oneblockchangetrackingfileiscreatedforeachdatafile.Bydefault,thefileiscreatedinBACKGROUND_DUMP_DEST.

C.Oneblockchangetrackingfileiscreatedforthedatabase.Bydefault,thefileiscreatedinDB_CREATE_FILE_DEST.

D.Oneblockchangetrackingfileiscreatedforthedatabase.Bydefault,thefileiscreatedinBACKGROUND_DUMP_DEST.

Answer:C

51.YouwanttousetheSQLTuningAdvisortogeneraterecommendationsforbadlywrittenSQLstatementsinyourdevelopmentenvironment.Whichthreesourcescanyouselectfortheadvisortoanalyze?(Choosethree.)

A.TopSQL

B.snapshots

C.SQLTuningsets

D.indexaccesspath

E.optimizerstatistics

F.materializedviewlogs

Answer:A,C,D

52.ThelossofwhichtwotypesoffilesmayrequirearecoverywiththeRESETLOGSoption?(Choosetwo.)

A.controlfiles

B.passwordfile

C.archivedlogfiles

D.system-criticaldatafilesforwhichalltheredoentriesarepresent

E.non-system-criticaldatafilesforwhichalltheredoentriesarepresent

Answer:A,C

53.Therewasmediafailureandyouneedtocheckthedatafilesforanyblockcorruption.Whichoptionwouldyouusetocreateareportonanycorruptionsfoundwithinthedatabase?

A.theDBNEWIDutility

B.theDBVERIFYutility

C.theANALYZEcommand

D.theRMANREPORTcommand

E.theRMANCROSSCHECKcommand

F.theCHECK_OBJECTprocedureoftheDBMS_REPAIRpackage

Answer:B

54.Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.Yoususpectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?

A.MemoryAdvisor

B.SegmentAdvisor

C.SQLAccessAdvisor

D.AutomaticWorkloadRepository(AWR)

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

Answer:C

55.Youhavecreatedaresourceplan,PROD_DB_PLAN,withthefollowingconsumergroupswiththerespectiveplandirectives:

ConsumergroupSALESwithCPU_P1as60andDEGREE_OF_PARALLELISMas4.

ConsumergroupMARKETwithCPU_P1as20.

ConsumergroupDEVwithCPU_P1as20.

ConsumergroupOTHERSwithCPU_P1as0andCPU_P2as100.

Whichtwostatementsarecorrectinthisscenario?(Choosetwo.)

A.Themaximumdegreeofparallelismforthemembersoftheconsumergroupsis4.

B.TheCPUallocationwillalwaysbeequalfortheconsumergroupsMARKETandDEV.

C.TheOTHERSconsumergroupwouldget100%oftheCPUifthereareunusedlevel1CPUresources.

D.TheSALESandMARKETconsumergroupswouldget100%oftheCPUifthereareunusedlevel2CPUresources.

E.ThemaximumdegreeofparallelismforthemembersoftheconsumergroupSALESis4withnorestrictionfortheremaininggroups.

Answer:C,E

56.AuserexecutesaqueryontheEMPtable,whichcontainsthousandsofrows,togetdetailsaboutemployeesinoneofthe

departments.Theuserreceivesthefollowingerror:

SQL>SELECTenameFROMempWHEREdeptno=10ORDERBYsal;

SELECTenameFROMempWHEREdeptno=10ORDERBYsal

ERRORatline1:

ORA-01157:cannotidentify/lockdatafile201-seeDBWRtracefile

ORA-01110:datafile201:'/u01/app/oracle/oradata/orcl/temp01.dbf'

Whatisapossiblereason?

A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.

B.Thedatabaseisopenedinrestrictedmode,soqueriesarenotallowed

C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.

D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.

E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisread-only.

Answer:A

57.YouexecutedthefollowingcommandinRecoveryManager(RMAN):

RMAN>RESTORECONTROLFILE;

Whichoperationmustyouperformbeforethiscommandisexecuted?

A.backupthecontrolfiletotrace

B.bringdatabasetotheMOUNTstate

C.openaconnectiontotheRMANrecoverycatalog,whichcontainstheRMANmetadataforthetargetdatabase

D.setthedatabaseID(DBID),butonlyiftheDB_NAMEparameterassociatedwiththetargetdatabaseisuniqueintherecoverycatalog

Answer:C

58.Exhibit

UsingDatabaseControl,youhavescheduledajobtoshrinktheTRANStableresidingontheTTtablespace.Thejobwouldrunat5:00p.m.everyFriday.Whenyouexaminethespaceusageofthetableafterthecompletionofthejob,youfindthatthetablehasnotbeenshrunk.Whatcouldhavebeenthereasonforthis?

A.ThetablespacethatcontainstheTRANStableisonline.

B.ThetablespacethatcontainstheTRANStableispermanent.

C.ThetablespacethatcontainstheTRANStableislocallymanaged.

D.ThesegmentspacemanagementofthetablespacethatcontainstheTRANStableismanualinnature.

Answer:D

59.Thewarningandcriticalthresholdvalueshavebeensetto85%and97%,respectively,foroneofthetablespaces.Thecurrenttablespacespaceusageis54%.Youmodifythewarningthresholdtobe50%andcriticalthresholdtobe53%inDatabaseControl.Whichstatementistrue?

A.Thenewsettingwouldbeappliedbutnoalertswouldberaisedimmediately.

B.Thenewsettingwouldbeappliedandanalertwouldberaisedimmediately.

C.Thenewsettingwouldbeignoredbecausethetablespacespaceusageismorethanthespecifiedthresholdvalue.

D.Thenewsettingwouldcauseanerrorbecausethetablespacespaceusageismorethanthespecifiedthresholdvalue.

Answer:A

60.YoudefinedtheRecoveryManager(RMAN)retentionpolicytorecoverywindowof7daysbyexecutingthefollowingcommand:

RMAN>CONFIGURERETENTIONPOLICYTORECOVERYWINDOWOF7DAYS;

Whenabackupisperformed,whatwouldbethestatusofthisbackupaftersevendays?

A.Thebackupwouldbemarkedasinvalid.

B.Thebackupwouldbemarkedasobsolete.

C.Thebackupwouldberemovedfromthemedia.

D.ThebackupwouldberemovedfromtheRMANrepository.

Answer:B

61.YouworkasadatabaseadministratoratCertkiller.com.Youareworkinginanonlinetransactionprocessing(OLTP)environment.Yourealizethatthesalaryforanemployee,John,hasbeenaccidentallymodifiedintheEMPLOYEEStable.Twodaysago,thedatawasinthecorrectstate.Flashbacklogsgeneratedduringlasttwodaysareavailableintheflashrecoveryarea.Whichoptionwouldyouchoosetobringthedatatothecorrectstatewhileensuringthatnootherdatainthesametableisaffected?

A.performpoint-in-timerecovery

B.performaFlashbackTableoperationtorestorethetabletothestateitwasintwodaysago

C.performaFlashbackDatabaseoperationtorestorethedatabasetothestateitwasintwodaysago

D.performFlashbackVersionsQueryandFlashbackTransactionQuerytodetermineallthenecessaryundoSQLstatements,andthenusethemforrecovery

Answer:D

62.WhenperformingabackupusingRecoveryManager(RMAN),whichfourtypesoffilescanbebackedupwiththeRMANBACKUPcommand?(Choosefour.)

A.datafile

B.passwordfile

C.archivelogfile

D.temporaryfile

E.onlineredologfile

F.thecurrentcontrolfile

G.thetnsnames.orafile

H.currentserverparameterfile

Answer:A,C,F,H

63.YouwererecentlyhiredbyCertkiller.comasadatabaseadministrator.Youareaskedtofindoutwhetherthecurrentlyfunctionallistenerprocess,namedL1,hasbeenpasswordprotectedornot.Youarenotfamiliarwiththefilesystemoftheneworganization.Howwouldyouaccomplishthetask?

A.byusingtheSTATUScommandoftheListenercontrolutility

B.byusingtheSTATUSL1commandoftheListenercontrolutility

C.byusingtheSHOWRULEScommandoftheListenercontrolutility

D.byusingtheSETPASSWORDcommandoftheListenercontrolutility

E.bysearchingforthePASSWORD_LISTENERentryinthelistener.orafile

Answer:B

64.ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT:

SQL>DESCv$FLASHBACK_DATABASE_STAT

NameNullType

BEGIN_TIMEDATE

END_TIMEDATE

FLASHBACK_DATANUMBER

DB_DATANUMBER

REDO_DATANUMBER

ESTIMATED_FLASHBACK_SIZENUMBER

WhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue?(Choosetwo.)

A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.

B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.

C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.

D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.

E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.

Answer:C,D

65.Youlostatemporaryfilethatbelongstothedefaulttemporarytablespaceinyourdatabase.Fromtheoptionsprovided,whichapproachwouldyoutaketosolvetheproblem?

A.flashbackthedatabase

B.importthetemporarytablespacefromthelastexport

C.restoreallthedatafilesandtemporaryfilesfromthelastfulldatabasebackupandperformarecovery

D.notperformarecovery,butcreateanewtemporarytablespace,makeitthedefaulttemporarytablespaceandthendroptheoldtablespace

Answer:D

66.WhichtwostatementsarecorrectregardingtheOracleFlashbackDropfeature?(Choosetwo.)

A.Recyclebinexistsforthetablesonlyinnon-SYSTEM,locallymanagedtablespaces.

B.Youcanflashbackadroppedtableprovidedrowmovementhasbeenenabledonthetable.

C.Ifyoudropanindexbeforedroppingitsassociatedtable,thentherecoveryoftheindexisnotsupportedwhenyouflashbackthedroppedtable.

D.WhenyouexecutetheDROPTABLESPACE?INCLUDINGCONTENTScommand,theobjectsinthetablespaceareplacesintherecyclebin.

E.Whenadroppedtableismovedtotherecyclebin,onlythetableisrenamedtoasystem-generatedname;itsassociatedobjectsandconstraintsarenotrenamed.

F.Ifyoudropatablethatisprotectedbytherecyclebin,thenassociatedbitmap-joinedindexesandmaterializedviewlogsarealsostoredintherecyclebin.

Answer:A,C

67.Youwanttocreateaconsumergroup,GROUP1,andyouexecutethefollowingcommandinthecommand-lineinterface:

SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP=>'group1',COMMENT=>'NewGroup');

Thiscommanderrorsoutdisplayingthefollowingmessage:

ERRORatline1:

ORA-01031:insufficientprivileges

ORA-06512:at"SYS.DBMS_RMIN",line115

ORA-06512:atSYS.DBMS_RESOURCE_MANAGER",line108

ORA-06512:atline1

Whatactionwouldyoutaketoovercomethiserror?

A.grantSYSDBAtotheuser

B.grantSYSOPERtotheuser

C.granttheRESOURCEroletotheuser

D.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuse

E.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe

DBMS_RESOURCE_MANAGER_PRIVSpackage

Answer:E

68.Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However,insteadofperformingamediarecovery,youdecidedtore-createtheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestore-createtheindexes?(Choosetwo.)

A.ONLINE

B.REVERSE

C.PARALLEL

D.COMPRESS

E.NOLOGGING

F.COMPUTESTATISTICS

Answer:C,E

69.Intheparameterfileofyourproductiondatabase,theFAST_START_MTTR_TARGETparameterissetto300tooptimize

instancerecovery.Whileobservingtheperformanceofthedatabaseduringinstancerecovery,youfindthattheredologfilesarenotsizedproperlytosupportthisactivity.Whichtwosourcescouldyouusetodeterminetheoptimalsizeoftheredologfiles?

(Choosetwo.)

A.theV$LOGview

B.theV$DBFILEview

C.theV$LOGFILEview

D.theV$INSTANCE_RECOVERYview

E.OracleEnterpriseManagerDatabaseControl

Answer:D,E

70.WhywouldyouusethefollowingFLASHBACKTABLEcommand?

FLASHBACKTABLEempTOTIMESTAMP('11:45'.'hh12:mi');

A.toundothechangesmadetotheEMPtablesincethespecifiedtime

B.torestoretheEMPtablethatwaswronglydroppedfromthedatabase

C.toviewthetransactionsthathavemodifiedtheEMPtablesincethespecifiedtime

D.toviewthechangesmadetotheEMPtableforoneormorerowssincethespecifiedtime

Answer:A

71.WhateffectshouldthelossofanindextablespacehaveonanOracleinstancethatisrunning?

A.instancehangs

B.instancegetsaborted

C.instancecontinuesrunning

D.instancegetsrestartedautomatically

Answer:C

72.Byusingthetransactionidentifierprovidedby______foraparticularrowchange,youcanusetheFlashbackTransactionQuerytoseetheoperationperformedbythetransaction.

A.FlashbackTable

B.FlashbackDatabase

C.FlashbackVersionQuery

D.TheRMANREPORTcommand

E.TheDBA_PENDING_TRANSACTIONSview

Answer:C

73.YouworkasadatabaseadministratoratCertkiller.com.Manually,yousettheconsumergroupofallofthenewlycreateduserstoMYDB_GRP.Youwanttheuserstobeabletochangetheirconsumergroupsaspertheapplicationrequirement.

Whatwasthefirststepthatwasneededintheprocesstoachievethisobjective?

A.TheusermusthavebeengrantedtheDBArole.

B.Theusermusthavebeengrantedtheswitchprivilegeasapartofarole.

C.TheusermusthavebeengrantedtheResourceManageradministratorprivilege.

D.TheusermusthavebeengrantedtheswitchprivilegebyusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage.

Answer:D

74.Whilesettingupthethresholdfortablespacespaceusagemetricsforoneofyourtablespaces,youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting?

A.Itwouldresultinanerrorbecausethewarningthresholdcannotbemorethanthecriticalthreshold.

B.Thewarningthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthecriticalthreshold.

C.Thecriticalthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthewarningthreshold.

D.Boththresholdvaluesareusedandalertsaregeneratedwhenspaceusageexceedstherespectivethresholdvalues.

Answer:A

75.Youhavecreatedaresourceplan,DB_PLAN,usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan?

A.assignuserstoconsumergroups

B.settheresourceplanfortheinstance

C.configureasimpleresourceplanandspecifyplandirectives

D.configureacomplexresourceplanandspecifyplandirectives

Answer:A

76.Exhibit

ViewingtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent(shownwitha"?`"=intheFlashbackDatabasearchitecture.

A.DBWn

B.RVWR

C.ARCH

D.RECO

E.TRWR

Answer:B

77.Case1:

1.Shutdownthedatabaseandperformabackup.

2.Restoreallthedatafiles.

3.Mountthedatabase.

4.Recoverthedatabase.

5.Withoutapplyingalltheredologfiles,openthedatabaseusingtheRESETLOGSoption.

6.Backupthedatabase.

Case2:

1.Shutdownthedatabaseandperformabackup.

2.Restoreonlythedatafilesofthetablespacewhereusererrordamagedthedata.

3.Mountthedatabase.

4.Recoverthedatabase.

5.OpenthedatabasewiththeRESETLOGSoption.

6.Backupthedatabase.

Case3:

1.Shutdownthedatabase.

2.Restorethedatafiles.

3.Openthedatabase.

4.Performrecoverytothecurrentpointintime.

Whichcasehasthecorrectstepsforanincompleterecovery?

A.Onlycase1

B.Onlycase2

C.Onlycase3

D.Case1and2

E.Case2and3

F.Case1and3

G.Allcases,case1,case2,case3

Answer:A

78.YouobservethattheseniordatabaseadministratoralwaysusesthefollowingcommandwhenconnectingtoRecoveryManager(RMAN),andthenstartsexecutingcommandstobackupthedatabasefiles:%rmantarget/.

Whatwouldbetheeffectofthiscommand?

A.RMANwouldusethecurrentoperatingsystemlocationtoplacethebackup.

B.RMANwouldusethecontrolfileofthetargetdatabasetomaintainthebackup.

C.RMANwouldusetherecoverycatalogofthetargetdatabasetomaintainthebackup.

D.RMANwouldusethecontrolfileofthetargetdatabasetomaintainthebackupmetadata.

E.RMANwouldusetherecoverycatalogofthetargetdatabasetomaintainthebackupmetadata.

Answer:D

79.YoudisabledtheFlashbackDatabasefeaturebyusingthefollowingcommand:

SQL>ALTERDATABASEFLASHBACKOFF;

Whatwouldbetheeffectofthiscommandontheexistingflashbacklogs?

A.Flashbacklogsarenotdeleted.

B.Flashbacklogsaredeletedautomatically.

C.FlashbacklogsaredeletedonlyifyouareusingRecoveryManager(RMAN)

D.FlashbacklogsaredeletedonlyifyouareusingOracleManagerFiles(OFM)

E.FlashbacklogsaredeletedonlyifyouareusingAutomaticStorageManagement(ASM)

Answer:B

80.Theproductiondatabasehasbeenfunctionalforthelastsevendays.Becauseofapplicationrequirements,someoftheinitializationparameterswerechangedduringruntimewithoutanycomments.Youhaveaskedtofindoutthevalueoftheparameterswhentheinstancewasstarted.Whichsourcewouldyouusetolocatethisinformation?

A.Fixedviews

B.Thealertlogfile

C.Theparameterfile

D.Theserverparameterfile

E.Dynamicperformanceviews

Answer:B

81.Youhaveadiskgroup,DGROUP1,withthreediskandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup:

ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES(MIRRORFINE);

Whichstatementistrue?

A.WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavethree-waymirroring.

B.WhenafileiscreatedinDGROUP1,theMY_TEMPtemplatebecomesthedefaulttemplate.

C.WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavetwo-waymirroringandfilestriping.

D.WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavethree-waymirroringandfilestriping.

E.WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavetwo-waymirroringbutnofilestriping.

Answer:C

82.Youlosttheindextablespaceinyourdatabase.Youarenotabletousetablespacepoint-in-timerecoveryontheindextablespace.Whatcouldbethereasonforthis?

A.Theindextablespacecontainsbitmapindexes.

B.Theindextablespacecontainsmorethanonedatafile.

C.Theindextablespacesupportsonlycompleterecovery.

D.Theindextablespaceisnotadictionary-managedtablespace.

E.Thereisadependencyrelationshipbetweenatableanditsindexes.

Answer:E

83.FortheV$SESSION_LONGOPSview,youfindthatsomeofthedatabaseusershavelong-runningqueriesthatconsumealotofCPUtime.Thiscausesperformanceproblemsforotherusersinthedatabase,whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime,butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis?

A.SettheCPUtimepercallintheusersprofile.

B.SettheCPUtimepersessionintheusersprofile.

C.SettheCPUlevelsfortheuser'sgroupusingResourceManager.

D.SettheTIMED_STATISTICSparametertoTRUEintheparameterfile.

Answer:C

84.Exhibit:

ViewtheExhibitandexaminethecharacteristicoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto,inordertofindinformationabouttablefragmentation?

A.MemoryAdvisor

B.SegmentAdvisor

C.SLQTuningAdvisor

D.SLQAccessAdvisor

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

Answer:B

85.Adatafilebecomecorruptedinyourdatabaseduetobadsectorsonthedisk.Becauseofcorruption,youlostalltheimportanttablesinthatdatafile.Whichmethodwouldyouuseforrecovery?

A.Flashbackallthetablesinthedatafile,onebyone.

B.Restorethedatafiletoanewlocationandperformamediarecovery.

C.Flashbackthedatabase,thereisnoneedtorestorethedatafile.

D.Restorethedatafilefromthemostrecentbackupandflashthedatabase.

Answer:B

86.ForwhichtwoSQLstatementscanyouusetheFlashbackTablefeaturetorevertatabletoitspreviousstate?(Choosetwo)

A.UPDATETABLE

B.CREATECLUSTER

C.TRUNCATETABLE

D.ALTERTABLEMOVE

E.INSERTINTO...VALUES

F.ALTERTABLE...DROPCOLUMN

G.ALTERTABLE...DROPPARTITION

Answer:A,E

87.Whatpurposewouldyouachievebyenablingtheblockchangetrackingfeature?

A.Eliminatethenecessityforbackups.

B.Performoptimizedimagecopybackups.

C.Performoptimizedincrementalbackups.

D.Enablecheckpoint(CKPT)toperformcheckpointingateveryblockchange.

E.Enabledatabasewriter(DBWn)towritechangedblockstodatafilesfaster.

Answer:C

88.YouexecutethefollowingRMANcommandintheordershownbelow:

BACKUPVALIDATEDATABASE;

BLOCKRECOVERCORRUPTIONLIST;

Whatwillthesecommandsdo?

A.Createabackupofthedatabaseandrecoverallcorruptedblocksfoundinthebackup.

B.Runabackupvalidationandlistallthelogicallycorruptblocksaswellasphysicallycorruptblocksinthedatabase.

C.RunabackupvalidationtopopulateV$COPY_CORRUPTIONview,andthenlistanycorruptblocksrecordedintheview.

D.RunabackupvalidationtopopulateV$DATABASE_BLOCK_CORRUPTIONview,andthenrepairanycorruptblocksrecordedintheview.

E.Runabackupvalidation,repairanycorruptblocksfoundduringthevalidationprocess,andthenupdateV$DATABASE_BLOCK_CORRUPTIONviewtoindicatewhichcorruptblockshavebeenrepaired.

Answer:D

89.InRecoveryManager(RMAN),youhavesetcontrolfileautobackuptoONbyusingthefollowingcommand:

CONFIGURECONTROLFILEAUTOBACKUPON;

Whichtwoeventswouldcausethecontrolfiletobebackedupautomatically?(Choosetwo)

A.Atablespaceistakenoffline.

B.Thedatabaseinstanceisrestarted.

C.Anewdatafileisaddedtoanexistingtablespace.

D.AsuccessfulbackupisrecordedintheRMANrepository.

E.TheRMANconnectionisdisconnectedfromthetargetdatabase.

Answer:C,D

90.YouareworkingonanOracleDatabase10gdatabase.ForwhichpurposeswouldyouusetheFlashbackTransactionQueryfeature?(Chooseallthatapply)

A.Torecoveradroppedtable.

B.Torecoveradroppedschema.

C.Torecoverdatafromatruncatedtable.

D.Toviewchangesmadebyallthetransactionsduringagivenperiodoftime.

E.Toviewchangesmadebyasingletransactionduringagivenperiodoftime.

Answer:D,E

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

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-->