【ocp-062】1z0-062最新考試題庫解析-第2次課

1、【CUUG內(nèi)部資料】OCP討論群：1015267481【OCP062】1Z0062最新考試題庫解析最新考試題庫解析第1次課次課序：OCP11g認(rèn)證即將結(jié)束，12c已經(jīng)越來越熱，考試共分為3個科目：071、062、063，071的題庫解析已經(jīng)上傳，這次整理的是062的考試題，雖然考題多變、不斷的增加新題，但有了下面的這些考題，相信會對廣大考生有幫助作用，順利通過OCP考試。QUESTION16Examinethestructureofth

2、esalestablewhichisstedinalocallymanagedtablespacewithAutomaticSegmentSpaceManagement(ASSM)enabled.NameNullTypePROD_IDNOTNULLNUMBERCUST_IDNOTNULLNUMBERTIME_IDNOTNULLDATECHANNEL_IDNOTNULLNUMBERPROMO_IDNOTNULLNUMBERQUANTITY

3、___SOLDNOTNULLNUMBER(102)AMOUNTSOLDNOTNULLNUMBER(102)Youwanttoperfmonlinesegmentshrinktoreclaimfragmentedfreespacebelowthehighwatermark.A.Rowmovementisenabled.B.Referentialintegrityconstraintsfthetablearedisabled.C.Noque

4、riesarerunningonthistable.D.Extradiskspaceequivalenttothesizeofthesegmentisavailableinthetablespace.E.Nopendingtransactionexistsonthetable.CrectAnswer:ASection:(none)Explanation使用shrink的前提條件：1）表所在的表空間必須使用ASSM（自動段空間管理）2、在

5、收縮表上必須啟用rowmovement選項QUESTION17WhichtaskwouldyourecommendbefeusingtheDatabaseUpgradeAssistant(DBUA)toupgradeasingleinstanceacle11gR2databasetoacleDatabase12cA.shuttingdownthedatabaseinstancethatisbeingupgradedB.executing

6、thecatctl.pltoruntheupgradeprocessesinparallelC.runningthePreUpgradeInfmationToolD.copyingthelistener.afiletothenewACLE_HOMECrectAnswer:CSection:(none)Explanation【CUUG內(nèi)部資料】OCP討論群：1015267481QUESTION20Examinethememyrelated

7、parameterssetintheSPFILEofanacledatabase:memy_max_target＝6Gmemy_target=5Gpga_aggregate_target=500Msga_max_size=0sga_target=0WhichstatementistrueA.OnlySGAcomponentsaresizedautomaticallyB.Memyisdynamicallyreallocatedbetwee

8、ntheSGAPGAasneeded.C.ThesizeofthePGAcannotgrowautomaticallybeyond500MB.D.ThevalueoftheMEMY_TARGETparametercannotbechangeddynamically.CrectAnswer:CSection:(none)Explanation在acle12cR1之前，沒有選項可以用來限制和控制PGA的大小。雖然你設(shè)置某個大小為PGA_AG

9、GREGATE_TARGET的初始參數(shù)，acle會根據(jù)工作負(fù)載和需求來動態(tài)地增大或減小PGA的大小。而在12c中，你可以通過開啟自動PGA管理來對PGA設(shè)定硬性限制，這需要對PGA_AGGREGATE_LIMIT參數(shù)進(jìn)行設(shè)置。因此，你現(xiàn)在可以通過設(shè)置新的參數(shù)來對PGA設(shè)定硬性限制以避免過度使用PGA。QUESTION21WhichtwostatementsaretrueaboutextentsA.Blocksbelongingtoane

10、xtentcanbespreadacrossmultipledatafiles.B.Datablocksinanextentarelogicallycontiguousbutcanbenoncontiguousondisk.C.Theblocksofanewlyallocatedextentalthoughfreemayhavebeenusedbefe.D.Datablocksinanextentareautomaticallyrecl