【OCP-062】1Z0-062最新考试题库解析-第2次课

《【OCP-062】1Z0-062最新考试题库解析-第2次课》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、【CUUG内部资料】OCP讨论群：1015267481【OCP-062】1Z0-062最新考试题库解析-第1次课序：OCP11g认证即将结束，12c已经越来越热，考试共分为3个科目：071、062、063，071的题库解析已经上传，这次整理的是062的考试题，虽然考题多变、不断的增加新题，但有了下面的这些考题，相信会对广大考生有帮助作用，顺利通过OCP考试。QUESTION16Examinethestructureofthesalestable,whichisstoredinalocallymanagedtablespacewithAutomaticSeg

2、mentSpaceManagement(ASSM)enabled.NameNull?Type--------------------------------------------------------------------------------------------------------------PROD_IDNOTNULLNUMBERCUST_IDNOTNULLNUMBERTIME_IDNOTNULLDATECHANNEL_IDNOTNULLNUMBERPROMO_IDNOTNULLNUMBERQUANTITY___SOLDNOTNULLN

3、UMBER(10,2)AMOUNTSOLDNOTNULLNUMBER(10,2)Youwanttoperformonlinesegmentshrinktoreclaimfragmentedfreespacebelowthehighwatermark.A.Rowmovementisenabled.B.Referentialintegrityconstraintsforthetablearedisabled.C.Noqueriesarerunningonthistable.D.Extradiskspaceequivalenttothesizeofthesegm

4、entisavailableinthetablespace.E.Nopendingtransactionexistsonthetable.CorrectAnswer:ASection:(none)Explanation使用shrink的前提条件：1）表所在的表空间必须使用ASSM（自动段空间管理）2、在收缩表上必须启用rowmovement选项QUESTION17WhichtaskwouldyourecommendbeforeusingtheDatabaseUpgradeAssistant(DBUA)toupgradeasingle-instanceOra

5、cle11gR2databasetoOracleDatabase12c?A.shuttingdownthedatabaseinstancethatisbeingupgradedB.executingthecatctl.plscripttoruntheupgradeprocessesinparallelC.runningthePre-UpgradeInformationToolD.copyingthelistener.orafiletothenewORACLE_HOMECorrectAnswer:CSection:(none)Explanation【CUUG

6、内部资料】OCP讨论群：1015267481Explanation/Reference:Reference:QUESTION18YourdatabaseisopenandthelistenerLISTNENERisup.Youissuethecommand:LSNRCTL>RELOADWhatistheeffectofreloadonsessionsthatwereoriginallyestablishedbylistener?A.Onlysessionsbasedonstaticlistenerregistrationsaredisconnected.B

7、.Existingconnectionsarenotdisconnected;however,theycannotperformanyoperationsuntilthelistenercompletesthere-registrationofthedatabaseinstanceandservicehandlers.C.Thesessionsarenotaffectedandcontinuetofunctionnormally.D.Allthesessionsareterminatedandactivetransactionsarerolledback.

8、CorrectAnswer:CSection:(none)Expl