Oracle 10g OCP 043 题库 91-140题 共185题
91.Considerthefollowingcommandtoaddanewdiskgroupcalled"tdgroupA"withtwofailovergroups:
CREATEDISKGROUPtdgroupANORMALREDUNDANCY
FAILOVERGROUPcontrol01DISK
'/devices/A1',
'/devices/A2',
'/devices/A3'
FAILOVERGROUPcontrol02DISK
'/devices/B1',
'/devices/B2',
'/devices/B3'm
Thedisk"/devices/A1"iscurrentlyamemberdiskofadiskgroupbythename"tdgroup1".
Whichtaskwouldbeaccomplishedbythecommand?
A.Thiscommandwouldresultinanerrorbecauseadiskgroupcanhaveonlyonefailovergroup.
B.Thiscommandwouldresultinanerrorbecausethe/devices/A1diskisamemberofanotherdiskgrouptdgroup1.
C.AnewdiskgroupcalledtdgroupAwillbeaddedwithtwofailovergroupsandthe/devices/A1diskwillgetreattachedtothenewdiskgroupwithoutbeingdetachedfromtheexistingone.
D.AnewdiskgroupcalledtdgroupAwillbeaddedwithtwofailovergroupsandthe/devices/A1diskwillbeignoredforthenewdiskgroupbecauseitisamemberofanexistingdiskgrouptdgroup1.
E.AnewdiskgroupcalledtdgroupAwillbeaddedwithtwofailovergroupsandthe/devices/A1diskgetsdetachedfromtheexistingdiskgrouptdgroup1andattachedtothenewdiskgrouptdgroupA.
Answer:B
92.Yourbusinesshasdepartmentalreportsthataregeneratedeveryday.Eachdepartmentmustusethesamesetofqueries,butaccessadifferentsubsetofdatainthetables,dependingonwhichdepartmentgeneratesthereport.Theformatofthereportsisbeingdeveloped;currently,theformatchangesdaily.Howwouldyouconfigurethedatabasetoensurethateachdepartmentgeneratesitsreport(basedonitstargetdata)usingthemostrecentreportformateveryday?
A.Byhavingeachuserrunthereportgenerationprocedureatthescheduledtime,supplyingthenecessaryinputvariables.
B.BycreatingaprogramusingDBMS_JOBthatacceptsoneormorevariables,andcreatingajobthatcallsthisprogramusingDBMS_JOB.
C.ByhavingeachuserscheduleajobusingDBMS_JOBthatacceptsoneormoreinputvariablesandcallsaprocedurethatgeneratesthereport.
D.ByhavingeachusercreateajobusingDBMS_SCHEDULERthatincludesalltheinformationandcommandsnecessarytogeneratethereport.
E.BycreatingaprogramusingDBMS_SCHEDULERthatacceptsoneormorevariables,andcreatingajobthatcallsthisprogramusingDBMS_SCHEDULER.
Answer:E
93.Youexecutethefollowingcommandtocreatetwoconsumergroups,FIN_GROUP1andPAY_GROUP1foraplan,PROD_PLAN:
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN(SIMPLE_PLAN=>'prod_plan',
CONSUMER_GROUP1=>'fin_group1',
GROUP1_CPU=>80,
CONSUMER_GROUP2=>'pay_group1',
GROUP2_CPU=>20);
END;
Whichthreestatementsaretrue?(Choosethree)
A.SYS_GROUPgets100%CPUresourcesatlevel1.
B.FIN_GROUP1gets80%CPUresourcesatlevel1.
C.FIN_GROUP1gets80%CPUresourcesatlevel2.
D.PAY_GROUP1gets20%CPUresourcesatlevel1.
E.PAY_GROUP1gets20%CPUresourcesatlevel2.
F.OTHER_GROUPgets100%CPUresourcesatlevel1.
G.OTHER_GROUPgets100%CPUresourcesatlevel2.
Answer:A,C,E
94.WhichstatementistrueregardingthecreationofnestedplansusingResourceManager?
A.Onlyonenestedsubplanisallowed.
B.Theplanscanbenesteduptofourlevels.
C.ResourceManagerdoesnotsupportnestedplans.
D.NestedplanscontrolonlythedegreeofparallelismbutnottheCPU.
E.EachnestedplangetsaproportionoftheCPUresourcesassignedtoitsparentgroup.
Answer:E
95.Youwantyourlistenertobepasswordprotectedtopreventitfrombeingshutdown.Youwanttoaccomplishthistaskwhilethelistenerisfunctional.Whichmethodcouldyouusetoachievethisobjective?
A.UsetheCHANGE_PASSWORDcommandoftheListenercontrolutility.
B.UsetheSETPASSWORDandSAVE_CONFIGcommandsoftheListenercontrolutility.
C.UsetheCHANGE_PASSWORDandSAVE_CONFIGcommandsoftheListenercontrolutility.
D.Manuallymodifythelistener.orafiletoincludethepasswordforthelistenerandrestartthelistener.
Answer:C
96.YouneedtochecktheEMP_EASTpartitionintheEMPLOYEEStableforphysicalcorruptions.Youalsoneedtoverifythattherowsbelongtothecorrectpartition.Whichoptioncouldyouuse?
A.LogMiner
B.TheDBNEWIDutility
C.TheDBVERIFYutility
D.TheANALYZEcommand
E.TheRMANREPORTcommand
F.TheRMANCROSSCHECKcommand.
G.TheRMANBLOCKRECOVERcommand.
Answer:D
97.UsersinyourproductiondatabasecomplainthattheyaregettingthefollowingerrormessagewhiletryingtoinsertrowsintotheORDERStable:
ERRORatline1:
ORA-01654:unabletoextendindexUSERS.ORDERS_INDby8intablespaceINDEXES
Whileinvestigating,youfindthattheINDEXEStablespacehasrunoutofspaceandthereisnomorefreespaceonthediskwherethedatafilesareavailable.Whichtwoactionscouldyouperformtoovercomethiserrorwithoutaffectingthequeriesthatarecurrentlybeingexecuted?(Choosetwo)
A.Dropandre-createtheinbox.
B.CoalescetheORDERS_INDindex.
C.CoalescetheINDEXEStablespace.
D.Dropandre-createtheORDERStable.
E.Rebuildtheindexonlineandmoveittoanothertablespace.
Answer:B,E
98.Considerthefollowingscenario:Youhaveadirectory,data,underthediskgrouptdgroupA.Youwanttocreateanaliasforoneofthedatafilesandyouexecutethefollowingcommand:
ALTERDISKGROUPtdgroupAADDALIAS'+tdgroupA/data/datafile.dbf'FOR'+tdgroupA.231.45678';
Whichtaskwouldbeaccomplishedbythecommand?
A.Thecommanddropsthefile+tdgroupA.231.45678.
B.Thecommandphysicallyrelocatedthefileto+tdgroupA/dataandrenamesthefiletodatafile.dbf.
C.Thecommandcreatesacopyofthe+tdgroupA.231.45678fileandplacesitin+tdgroupA/dataafterrenamingthefiletodatafile.dbf.
D.Thecommandcreatesanalias,datafile.dbf,andplacesitin+tdgroupA/dataanddoesnotremovethetdgroupA231.45678file.
E.Thecommandcreatesafile,datafile.dbf,in+tdgroupA/dataandremovedthereferencesfor+tdgroupA.231.45678fromthedatadictionaryviews.
Answer:D
99.Youlostadatafilethatbelongstoanindextablespaceinyourdatabase,whichoperatesinARCHIVELOGmode.Lossofthedatafileresultedinincreasedresponsetimeonyourqueries.
Whichtwooptionswouldyouusetosolvethisproblem?(Choosetwo)
A.Restorethelostdatafilefromthebackup,andthenflashbackthedatabase.
B.Restorethedatafilepertainingtoindextablespace,andthenrecoverthetablespace.
C.Restoreallthedatafiles,andthenperformanincompleterecoverytogetthetablespaceback.
D.Restoreallthedatafiles,andthenperformanincompleterecoveryusingthebackupcontrolfile.
E.Dropandre-createtheindextablespace,andthenre-createalloftheindexesinthattablespace.
Answer:B,E
100.YoudatabaseoperatesinARCHIVELOGmodeanduser-managedconsistentbackupsareperformedeverySundaynight.OnTuesday,at9:00a.m.thecurrentlogsequencenumberwas369.Also,onTuesdayyoulostthedatafilebelongingtotheSYSTEMtablespaceandanachivelogfile(sequencenumber356)thatcontainedredoentriesbetween8:00a.m.and8.30a.m.
Withreferencetothisscenario,whatwouldyoudotorecoverthedatabase?
A.RestoreallthedatafilesfromlastSunday'sbackup,andthenperformatime-basedrecovery.
B.RestoreallthedatafilesfromlastSunday'sbackup,andthenperformacancel-basedrecovery.
C.RestoreallthedatafilesfromlastSunday'sbackup,andthenperformachange-basedrecovery.
D.RestoreonlydatafilesthatbelongtotheSYSTEMtablespacefromlastSunday'sbackup,andthenperformacompleterecovery.
Answer:B
101.Youexecutedthefollowingqueryinyourdatabase:
SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;
Whatwouldyoudeterminefromtheoutput?
A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.
B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.
C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.
D.Theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase.
Answer:D
102.Whiledesigningthedatabaseforoneofyouronlinetransactionprocessing(OLTP)applications,youwanttoachievethefollowing:
a)highavailabilityofdata
b)fasterprimarykeyaccesstothetabledata
c)compactstorageforthetable
Whichtypeoftableswouldyouusetoachievetheseobjectives?
A.heaptables
B.objecttables
C.partitionedtables
D.index-organizedtables(IOTs)
Answer:D
103.YouareusingOracleDatabase10g.ThelogLOG_ARCHIVE_FORMATparameterissetto'LOG%t_%_s_%r.dbf'.
Whyis%rusedinthefilenameformat?
A.Touniquelyidentifythearchivedlogfileswiththerestoreoperation.
B.Touniquelyidentifythearchivedlogfileswiththeredologgroupnumber.
C.Touniquelyidentifythearchivedlogfilesforeachincarnationofthedatabase.
D.Touniquelyidentifythearchivedlogfileswiththenumberofrecoveryoperationsperformed.
Answer:C
104.Exhibit:
Exhibit:
ViewtheExhibits.
YouperformedoperationsontheDEPT4tableasshownintheExhibit.WhenyouperformtheFlashbackVersionsQuery,youfindthatthefirsttwoupdatesarenotlisted.
Whatcouldbethereason?
A.Therowmovementisnotenabledonthetable.
B.Thefirsttwoupdateswerenotexplicitlycommitted.
C.TheFlashbackVersionsQuerylistsonlythemostrecentupdate.
D.TheFlashbackVersionsQuerystopsproducingrowsafteritencountersatimeinthepastwhenthetablestructurewaschanged.
Answer:D
105.Exhibit:
ViewtheExhibit.
Youhavemorethanonetableintherecyclebinhavingthesameoriginalname,DEPT2.YoudonothaveanytablewiththenameDEPT2inyourschema.Youexecutedthefollowingcommand:
PURGETABLEdept2;
Whichstatementiscorrectinthisscenario?
A.AllthetableshavingthesameoriginalnameasDEPT2willbepurgedfromtherecyclebin.
B.Thetablewithdropscn=1928151(oldestdropscn)willbepurgedfromtherecyclebin.
C.Thetablewithdropscn=1937123(mostrecentdropscn)willbepurgedfromtherecyclebin.
D.Noneofthetableswillbepurgedbecausetherearemultipleentrieswiththesameoriginalnameintherecyclebin.
Answer:B
106.WhichtypeofPL/SQLconstructwouldyouusetoautomaticallycorrecttheerrorresultingfromastatementthatwassuspendedduetoaspace-relatedproblem?
A.functions
B.package
C.procedure
D.databasetrigger
E.anonymousPL/SQLblock
Answer:D
107.InanOracle10gdatabase,thein-memorystatisticsaregatheredatregularintervalsandusedtoperformgrowth-trendanalysisandcapacityplanningofthedatabase.Whichcomponentstoresthesestatistics?
A.Recoverycatalog
B.OracleEnterpriseManagerRepository
C.AutomaticWorkloadRepository(AWR)
D.Oracle10gEnterpriseManagerGridControl
E.AutomaticDatabaseDiagnosticMonitor(ADDM)
Answer:C
108.Youhavebeenassignedtomanageasetofdatabases.ThepreviousDBAdidnotleaveyounotesregardingthestructureofeachofthedatabases.Whileanalyzinganinstance,younoticethatthesystemidentifier(SID)fortheinstanceissetto'+ASM'.
Whatisthepurposeofthisinstance?
A.Thisinstanceisbeingusedtomanagetheoperatingsystemfiles.
B.Thisinstanceisbeingusedtomanagethefilesofotherdatabases.
C.Thisinstanceisbeingusedtomanagetheinstancesofotherdatabases.
D.Thisinstanceisbeingusedtomanagethebackgroundprocessesofotherinstances.
Answer:B
109.Inoneofyouronlinetransactionprocessing(OLTP)applications,mostusersfrequentlymodifythevalues,includingthekeyvalues,oftheapplicationtables.Someusersgenerateapplicationreportsbyusingmultipleapplicationtables.Whatisthebesttablestructurethatyoucanusetogainoptimalperformance?
A.Heaptable
B.Objecttable
C.Externaltable
D.Clusteredtable
E.Globaltemporarytable
F.Index-organizedtable(IOT)
Answer:A
110.YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager(RMAN)toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeing
accessedbyusers?(Choosetwo)
A.Backupofofflinetablespaces.
B.Backupofread-onlytablespaces.
C.Backupofsystem-criticaltablespaces.
D.Backupofonline,locallymanagedtablespaces.
E.Backupofread/writedictionary-managedtablespaces.
Answer:A,B
111.Youareworkinginanonlinetransactionprocessing(OLTP)environment.YouusedtheFLASHBACKTABLEcommandtoflashbacktheCUSTOMERStable.BeforeexecutingtheFLASHBACKTABLEcommand,theSystemChangeNumber(SCN)was663571.AfterflashingbacktheCUSTOMERStable,yourealizethatthetableisnotinthecorrectstateandtheresultantchangesarenotwhatyouhaddesired.So,youneedtoreversetheeffectsoftheFLASHBACKTABLEcommandwhileensuringthat:
a)Nootheruserdatainthedatabaseisaffected.
b)Theoperationtakestheminimumpossibletime
Whichoptionwouldyouchoose?
A.UseROLLBACKcommandwithSCN663571.
B.PerformFlashbackTransactionQuerywithSCN663571.
C.ExecutetheFLASHBACKDATABASEstatementtoretrievetheCUSTOMERStableasitwasatSCN663571.
D.ExecuteanotherFLASHBACKTABLEstatementtoretrievetheCUSTOMERStableasitwasatSCN663571.
Answer:D
112.Becauseofhardwarefailure,youdecidedtodroparedologmemberfromthedatabase.
Whichconditionshouldbemettodroparedologfile?
A.Theredologfileshouldbelongtoanactivegroup.
B.Theredologfileshouldbelongtoaninactivegroup.
C.Theredologfileshouldbelongtothecurrentgroup.
D.Theredologfilecanbedroppedonlyifallthetransactionsarestopped.
E.Beforearedologfileisdropped,itshouldbedeletedfromtheoperatingsystem(OS).
Answer:B
113.Inyourproductiondatabase,youhavemultipleresourceplandirectivesthatrefertothecustomergroupDB_GRP.Whichtwostatementsarecorrect?(Choosetwo)
A.TheparalleldegreelimitforDB_GRPwillbetheminimumofalltheincomingvalues.
B.TheparalleldegreelimitforDB_GRPwillbethemaximumofalltheincomingvalues.
C.ThemaximumestimatedexecutiontimeforDB_GRPwouldbethemostnonrestrictiveofallincomingvalues.
D.IfasessionswitchedfromtheDB_GRPconsumergrouptoanotherconsumergroupbecauseitexceededtheprescribedswitchtime,thenthatsessionwouldnotexecuteiftheactivesessionpoolforthenewconsumergroupwasfull.
E.IsasessionswitchedfromtheDB_GRPconsumergrouptoanotherconsumergroupbecauseitexceededtheprescribedswitchtime,thenthatsessionwouldexecuteeveniftheactivesessionpoolforthenewconsumergroupwasfull.
Answer:A,E
114.Bymistake,youranthebatchjob(forupdatingtheBILL_DETAILStable)twice.YouarenotsurewhichrowsintheBILL_DETAILStablewereaffected.Youneedtoidentify:
a)Alistofchangesmadealongwiththetransactionidentifierofeachchange.
b)ThenecessarySQLstatementstoundotheerroneouschanges.
Whichoptionwouldyouchoose?
A.RMANonly.
B.FlashbackTableonly.
C.FlashbackVersionQueryonly.
D.FlashbackDatabaseandFlashbackTransactionQuery.
E.FlashbackVersionQueryandFlashbackTransactionQuery.
Answer:E
115.YouusedthefollowingcommandinRecoveryManager(RMAN)aspartoftherecoveryprocess:
RESTORECONTROLFILEFROMAUTOBACKUP;
HowdoesRMANfindthecontrolfileautobackup?(Choosealltheapply)
A.Byusingthetracefile.
B.Byusingthealertlogfile.
C.ByusingthedatabaseID.
D.Byusingtheserverparameterfile.
E.ByusingtheV$CONTROLFILEview.
F.Byusingtheautobackupformatconfigurationsetting.
Answer:C,F
116.Inoneofyouronlinetransactionprocessing(OLTP)applications,usersaremanipulatingandqueryingadatabasetablesimultaneously.FromtheSegmentAdvisor,youfindthatoneofthetablesishighlyfragmentedandyouwanttoshrinkthetableimmediatelywithoutaffectingthecurrentlyactivequeries.WhichoptionwouldyouusewiththeALTERTABLEcommandtoachievethisobjective?
A.REBUILD
B.CASCADE
C.TRUNCATE
D.ROWMOVEMENT
E.SHRINKSPACECOMPACT
F.SHRINKSPACECASCADE
Answer:E
117.Youareworkinginadedicatedserverenvironment.YourdatabaseisrunningintheautomaticProgramGlobalArea(PGA)memorymanagementmode.Whichtwostatementsarecorrectinthisscenario?(Choosetwo)
A.TheWORK_AREASIZE_POLICYinitializationparametercannotbesettoAUTO.
B.TheOracledatabaseautomaticallycontrolstheamountofPGAmemoryallottedtoSQLworkareas.
C.SettingthevalueoftheSGA_TARGETinitializationparameterto0willdisabletheautomaticPGAmemorymanagement.
D.TheSORT_AREA_SIZEparameterisignoredbyallthesessionsrunningintheautomaticPGAmemorymanagementmode.
Answer:B,D
118.UsersareperformingalargevolumeofinsertsanddeletesontheapplicationtablesintheAPPStablespace.YouobservethatthereareseveralwarningalertsbeinggeneratedfortheAPPStablespacespaceusagemetrics.Currently,thewarningthresholdforthetablespaceusagemetricsissetto70%.Tomakethegeneratedalertsmoreusefulasaproblemidentificationtool,youwanttoreducethefrequencyofalertgenerationforthetablespaceusagemetricsfortheAPPStablespace.Whatshouldyoudo?
A.DisableSQLtracingfortheAPPStablespace.
B.DisableloggingattributesfortheAPPStablespace.
C.Modifythetablespacetobeadictionary-managedtablespace.
D.IncreasethecriticalthresholdvalueforthetablespacespaceusagemetricsfortheAPPStablespace.
E.IncreasethewarningthresholdvalueforthetablespacespaceusagemetricfortheAPPStablespace.
Answer:E
119.UsingOracleScheduleryouhavescheduledtwojobs,JOB_AandJOB_B,torunat9:00p.m.everyFriday.Youwantboththejobstouseasingleresourceplan,WEEKEND_PLAN.Whichtaskmusthavealreadybeenperformedtoenableyoutoachievethisobjective?
A.AwindowmusthavebeencreatedwiththeWEEKEND_PLANresourceplan.
B.AprogrammusthavebeencreatedwiththeWEEKEND_PLANresourceplan.
C.AjobclassmusthavebeencreatedwiththeWEEKEND_PLANresourceplan.
D.AwindowsgroupmusthavebeencreatedwiththeWEEKEND_PLANresourceplan.
Answer:A
120.WhatarethetwoadvantagesofRMANBlockMediaRecovery(BMR)overfile-levelrecovery?(Choosetwo)
A.BMRlowersthemeantimetorecover(MTTR).
B.BMRsupportspoint-in-timerecoveryofindividualdatablocks.
C.BMRenablesyoutouseincrementalbackupsforblockrecovery.
D.BMRenablesrecoveryevenwhenthedatabaseisnotmountedoropen.
E.BMRenablesyoutouseproxybackupstoperformblockmediarecovery.
F.BMRenablesincreasedavailabilityofdataduringrecoverybecausethedatafilerequiresarecoverycanremainonline.
Answer:A,F
121.WhilecreatingaschedulerwindowusingtheDBMS_SCHEDULERpackage,auserloggedinasDBMGRgetstheerrormessageinsufficientprivileges?Whichtwocommandswouldyouusetoresolvethiserror?(Choosetwo)
A.GRANTdbaTOdbmgr;
B.GRANTconnectTOdbmgr;
C.GRANTresourceTOdbmgr;
D.GRANThs_admin_roleTOdmbgr;
E.GRANTmanageschedulerTOdbmgr;
Answer:A,E
122.YouhavesetthevalueoftheNLS_TIMESTAMP_TZ_FORMATparameterintheparameterfiletoYYYY-MM-DD.Thedefaultformatofwhichtwodatatypeswouldbeaffectedbythissetting?(Choosetwo)
A.DATE
B.TIMESTAMP
C.INTERVALYEARTOMONTH
D.INTERVALDAYTOSECOND
E.TIMESTAMPWITHLOCALTIMEZONE
Answer:B,E
123.Foranincompleterecovery,whichfourbackuptypescanbeusedbyRecoveryManager(RMAN)torestoredatafiles?(Choosefour)
A.RMANimagecopies.
B.RMANdatabasebackups.
C.RMANtablespacebackups.
D.User-managedbackupsplacedintheflashrecoveryarea.
E.User-managedbackupsthathavebeencatalogedwithRMAN.
F.User-manageddatafilebackupsforwhichthepullpathnameisspecified.
Answer:A,B,C,E
124.YouareusingOracleDatabase10g.YouperformedanincompleterecoveryofyourdatabaseandopenedthedatabasewiththeRESETLOGSoption.WhatistheeffectofopeningthedatabasewiththeRESETLOGSoption?(Choosetwo)
A.ThisoperationresetstheSCNforthedatabase.
B.Thisoperationcreatesanewincarnationofthedatabase.
C.Thisoperationmovesalltheredologfilestoadifferentlocation.
D.Thisoperationdeletestheoldredologfilesandcreatesnewredologfiles.
E.ThisoperationupdatesallcurrentdatafilesandonlineredologsandallsubsequentarchivedredologswithanewRESETLOGSSCNandtimestamp.
Answer:B,E
125.WhichstatementistruewhilecreatingsubplansusingResourceManager?
A.Thesubplanmustbelongtotheconsumergroup,SYS_GROUP.
B.ThetotalCPUusageatanygivenlevelmustbelessthan100%.
C.Thesubplanscanbeusedtorestrictthedegreeofparallelismforauser.
D.Youcanusearesourceplaninsteadofaconsumergrouptoimplementapriorityrankingwithintheplan.
Answer:D
126.YourdatabaseisfunctioninginARCHIVELOGmode.Inwhichtwosituationswouldyouperformacancel-basedrecovery?(Choosetwo)
A.Youfindthatoneoftheredologmembersineachredologgroupislost.
B.YoufindthatadatafilethatbelongstotheUSERStablespaceisdamaged.
C.YoufindthatadatafilethatbelongstotheSYSTEMtablespaceisdamaged.
D.Youfindthatthecurrentredologgroupisdamagedandisnotavailableforrecovery.
E.Yourealizedwhileperformingarecoverythatanarchivedredologfileneededforrecoveryislost.
Answer:D,E
127.Inyourtestdatabase,youhavecreatedtheORDERStableasanindex-organizedtable(IOT).Tofacilitatefasterquerying,youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegreeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason,youfindthatthemappingtablesegmentisfragmented,leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata?
A.Exportandimportthemappingtable.
B.Dropandre-createthemappingtable.
C.Truncatethemappingtableandreinsertthevalues.
D.UsetheALTERTABLE..REBUILDcommandtodefragmentthemappingtable.
Answer:B
128.Amediafailurehasoccurred.Thishasresultedinallthemembersofthenexthoploggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?
A.Thedatabasere-createdthemissingredologfilesautomatically.
B.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.
C.Thedatabaseallowsonlyqueries,nootherstatementsareallowed.
D.Thedatabasereturnsanderrorandthedatabaseinstanceshutsdown.
E.Theusersessionsthatgenerateredologsareterminatedautomatically.
Answer:D
129.Considerthefollowingcommandtocreateatablespaceinyourproductiondatabase(whichisusinganAutomaticStorageManagement[ASM]instancetomanagethedatabasefiles):
CREATETABLESPACEuser_tbspDATAFILE'+dgroup3(usder_temp)/user_files/user_tbsp'SIZE200M;
Whatwouldbetheresultofthiscommand?
A.Itwouldresultinanerrorbecausethetemplatecannotbeusedalongwiththediskgroup.
B.Itwouldresultinanerrorbecausethepathcannotbespecifiedwhilecreatingatablespaceinadiskgroup.
C.Itwouldcreateatablespacewithadatafilethathasanalias,anditsattributesaresetbytheuser-definedtemplate.
D.Itwouldcreateatablespacewithadatafilethatdoesnothaveanalias,anditsattributesaresetbytheuser-definedtemplate.
Answer:C
130.Youenabledtheflashbackloggingfeature,butyouhavenotspecifiedthelocationoftheflashrecoveryarea.
Whichlocationwouldbeusedasthedefaultlocationfortheflashrecoveryarea?
A.Thelocationusedforcontrolfiles.
B.Thelocationusedforredologfiles.
C.Thelocationsetbyusing$ORACLE_BASE.
D.Thelocationsetbyusing$ORACLE_HOME.
E.ThelocationsetbyusingCORE_DUMP_DEST.
F.ThelocationsetbyusingBACKGROUND_DUMP_DEST.
Answer:C
131.WhichthreemethodscanyouusetorunanAutomaticDatabaseDiagnosticMonitor(ADDM)analysisoveraspecifictimeperiod?(Choosethree.)
A.EnterpriseManagerGUI
B.DBMS_TRACEpackageAPIs
C.DBMS_ADVISORpackageAPIs
D.DBMS_MONITORpackageAPIs
E.$ORACLE_HOME/rdbms/admin/addmrpt.sqlscript
Answer:A,C,E
Explanation:
TomakeuseofADDM,aPL/SQLinterfacecalledDBMS_ADVISORhasbeenimplemented.ThisPL/SQLinterfacemaybecalledthroughthesupplied$ORACLE_HOME/rdbms/admin/addmrpt.sqlscript,calleddirectly,orusedincombinationwiththeOracleEnterpriseManagerapplication.BesidesthisPL/SQLpackageanumberofviews(withnamesstartingwiththeDBA_ADVISOR_prefix)allowretrievaloftheresultsofanyactionsperformedwiththeDBMS_ADVISORAPI.ThepreferredwayofaccessingADDMisthroughtheEnterpriseManagerinterface,asitshowsacompleteperformanceoverviewincludingrecommendationsonhowtosolvebottlenecksonasinglescreen.WhenaccessingADDMmanually,youshouldconsiderusingtheADDMRPT.SQLscriptprovidedwithyourOraclerelease,asithidesthecomplexitiesinvolvedinaccessingtheDBMS_ADVISORpackage.
132.WhichbackgroundprocessdoesAutomaticSharedMemoryManagementusetocoordinatethesizingofmemorycomponents?
A.PMON
B.SMON
C.MMNL
D.MMAN
E.MMON
Answer:D
TheAutomaticSharedMemoryManagementfeatureusesanewbackgroundprocessnamedMemoryManager(MMAN).MMANservesastheSGAMemoryBrokerandcoordinatesthesizingofthememorycomponents.TheSGAMemoryBrokerkeepstrackofthesizesofthecomponentsandpendingresizeoperations
133.WhichsixfilesaremaintainedintheFlashRecoveryArea?(Choosesix.)
A.controlfile
B.RMANfiles
C.passwordfile
D.parameterfile
E.flashbacklogs
F.datafilecopies
G.coredumpfiles
H.archivedlogfiles
I.RMANrecoveryscripts
J.controlfileautobackpus
Answer:A,B,E,F,H,J
TheFlashRecoveryAreaisaunifiedstoragelocationforallrecovery-relatedfilesandactivitiesinanOracleDatabase.ItincludesControlFile,ArchivedLogFiles,FlashbackLogs,ControlFileAutobackups,DataFiles,andRMANfiles.
134.Considerthefollowingscenario:Youhaveadirectory,data,underthediskgrouptdgroupA.Youwanttocreateanaliasforoneofthedatafilesandyouexecutethefollowingcommand:
ALTERDISKGROUPtdgroupAADDALIAS'+tdgroupA/data/datafile.dbf'FOR'+tdgroupA.231.45678';
Whichtaskwouldbeaccomplishedbythecommand?
A.Thecommanddropsthefile+tdgroupA.231.45678
B.Thecommandphysicallyrelocatesthefileto+tdgroupA/dataandrenamesthefiletodatafile.dbf.
C.Thecommandcreatesacopyofthe+tdgroupA.231.45678fileandplacesitin+tdgroupA/dataafterremainingthefiletodatafile.dbf.
D.Thecommandcreatesasynonym,datafile.dbf,andplacesitin+tdgroupA/dataanddoesnotremovethe+tdgroupA.231.45678file.
E.Thecommandcreatesafile,datafile.dbf,in+tdgroupA/dataandremovesthereferencesfor+tdgroupA.231.45678fromthedatadictionaryviews.
Answer:D
Aliasnames(orjust"aliases")areintendedtoprovideamoreuser-friendlymeansofreferringtoASMfiles,ratherthanusingthesystem-generatedfilenames.Youcancreateanaliasforafilewhenyoucreateitinthedatabase,oryoucanaddanaliastoanexistingfileusingtheADDALIASclauseoftheALTERDISKGROUPstatement.Youcancreateanaliasinanysystem-generatedoruser-createdASMdirectory.Youcannotcreateanaliasattherootlevel(+),however.Thefollowingstatementaddsanewaliasnameforasystem-generatedfilename:
ALTERDISKGROUPdgroup1ADDALIAS'+dgroup1/mydir/second.dbf'FOR'+dgroup1/sample/datafile/mytable.342.3';
135.Exhibit
OnetheeveningofApril22,youareworkingonadatabasecreatedusingOracleDatabase10g.ThisdatabaseoperatesintheARCHIVELOGmode.Youdiscoverthatyouneedcrucialdatathatwasdroppedfromthedatabaseat8:00a.m.NofullbackuphasbeentakenafterApril15.Whatwouldyoudo?
A.recoverthedatabaseuntilApril10
B.recoverthedatabaseuntilApril15
C.recoverthedatabaseuntil227:59a.m.
D.recoveryisnotpossible;manuallyre-createtheobject
Answer:C
RMANsimplifiesrecoveryoperationsusingbackupstakenfromearlierdatabaseincarnationsothatitiseasyasrecoveringabackupfromthesameincarnation.ThesimplifiedrecoverythroughRESETLOGSfeatureisanenhancementtorecoveryoperationssothatpreviousincarnationbackupscanbeusedforrecoveryofthecurrentdatabaseincarnation.Youusethisfeaturewhenyouhaveperformedanincompleterecovery(orarecoveryusingabackupcontrolfile)andopenedthedatabasewiththeRESETLOGSoption.
Toperformincompleterecovery,usetheSETUNTILcommandtospecifythetime,SCN,restorepoint,orlogsequencenumberatwhichrecoveryterminates.Alternatively,specifytheUNTILclauseontheRESTOREandRECOVERcommands.
136.YouareunabletomovetheUnifiedJobScheduleroccupantfromtheSYSAUXtablespacetotheUSERStablespace.Whatcouldbethereason?
A.NoneoftheSYSAUXoccupantscanberelocated.
B.TheUSERStablespaceisabigfiletablespace(BFT).
C.TheunitedJobScheduleroccupantcannotberelocated.
D.TheSYSAUXoccupantscanberelocatedtotheSYSTEMtablespaceonly.
Answer:C
A-Nottrue.Sameofftheoccupantscanbemove
B-Nottrue.TheUSERSoccupant,isn't,bydefaultaBFTtablespace,andeventought,youshouldbeabletomoveanythingtoaBFTtablespace.Thepointit'sabouttomove,SYSAUXoccupant.
C-Trueanswer,asyouconcheck,bythefollowingquery:
SELECToccupant_name,move_procedure,FROMv$sysaux_occupants;
D-Nottrue.CanmoveSYSAUXoccupants,whemispossible,toanytablespacethatyouwant.
137.Youenabledblockchangetrackingforfasterincrementalbackupsinyourdatabase.
Whichbackgroundprocesswritestothechangetrackingfile?
A.RBAL
B.CKPT
C.SMON
D.PMON
E.MMON
F.CTWR
G.DBWR
Answer:F
CTWR:ThisisanewprocessChangeTrackingWriter(CTWR)whichworkswiththenewblockchangedtrackingfeaturesin10gforfastRMANincrementalbackups.
138.Youwanttoenforceacompany'sbusinesspolicyonseveralobjectsbyusingasinglepolicyfunction.Whichtwotypesofpoliciescanbeassignedtothepolicy_typeargumentinthedbms_rls.add_policyproceduretoachievetheaboveobjective?(Choosetwo.)
A.DBMS_RLS.STATIC
B.DBMS_RLS.DYNAMIC
C.DBMS_RLS.SHARED_STATIC
D.DBMS_RLS.CONTEXT_SENSITIVE
E.DBMS_RLS.SHARED_CONTEXT_SENSITIVE
Answer:C,E
DBMS_RLS.SHARED_STATICThepolicyfunctionexecutesonce,Once,thenthepredicateiscachedintheSGA,andit'sSharedAcrossMultipleObjects,likeHostingenvironments,suchasdatawarehouseswherethesamepredicatemustbeappliedtomultipledatabaseobjectsDBMS_RLS.SHARED_CONTEXT_SENSITIVEThepolicyfunctionexecutesfirsttimeandtheobjectisreferenceinadatabasesessionPredicatesarecachedintheprivatesessionmemoryUGAsopolicyfunctionscanbesharedamongobjects.
139.ThedatabaseiscurrentlyrunningintheNOARCHIVELOGmode.WhatwouldbethefirststeptoconfigureFlashbackDatabase?
A.Enableflashbacklogging.
B.StartthedatabaseintheARCHIVELOGmode.
C.IssuetheALTERDATABASEFLASHBACKON;command.
D.SettheFAST_START_MTTR_TARGETinitializationparameter.
Answer:A
Hereistheproblem...thequestionask"forthefirststep"...ButthedatabaseMUSTbeinarchivelogmodeanddeflashrecoveyareaMUSTbeenable,thusIbelivetheanswercorrectwouldbeAandB.
FlashbackDatabaseusesitsownloggingmechanism,creatingflashbacklogswhicharestoredintheflashrecoveryarea.YoucanonlyuseFlashbackDatabaseifflashbacklogsareavailable.Therefore,youmustsetupyourdatabaseinadvancetocreateflashbacklogsifyouwanttotakeadvantageofthisfeature.
TherequirementsforenablingFlashbackDatabaseare:
*YourdatabasemustberunninginARCHIVELOGmode,becausearchivedlogsareusedintheFlashbackDatabaseoperation.
*Youmusthaveaflashrecoveryareaenabled,becauseflashbacklogscanonlybestoredintheflashrecoveryarea.
140.YouhaveconfiguredAutomaticSharedMemoryManagement.Whichfourmemorystructureswouldbeautomaticallytuned?(Choosefour)
A.logbuffer
B.Javapool
C.Largepool
D.FixedSGA
E.Sharedpool
F.Streamspool
G.Keepbuffercache
H.Databasebuffercache
Answer:B,C,E,H
------------------------------------------------------------------------------
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