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

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

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

2、--------------------------------------------undo_managementstringAUTOundo_retentioninteger1200undo_tablespacestringUNDOTBS1Youexecutethefollowingcommand:SQL>ALTERTABLESPACEundotbs1RETENTIONNOGUARANTEE;Whichstatementistrueinthisscenario?A.Undodataiswrittentoflashbacklogsafter1200seconds

3、.B.Inactiveundodataisretainedfor1200secondsevenifsubsequenttransactionsfailduetolackofspaceintheundotablespace.C.YoucanperformaFlashbackDatabaseoperationonlywithinthedurationof1200seconds.D.Anattemptismadetokeepinactiveundofor1200secondsbuttransactionsmayoverwritetheundobeforethattimeh

4、aselapsed.CorrectAnswer:DSection:(none)Explanation验证过QUESTION2AuserestablishesaconnectiontoadatabaseinstancebyusinganOracleNetconnection.Youwanttoensurethefollowing:1.Theuseraccountmustbelockedafterfiveunsuccessfulloginattempts.2.Datareadpersessionmustbelimitedfortheuser.3-Theusercanno

5、thavemorethanthreesimultaneoussessions.4.Theusermusthaveamaximumof10minutessessionidletimebeforebeingloggedoffautomatically.Howwouldyouaccomplishthis?A.bygrantingasecureapplicationroletotheuserB.byimplementingDatabaseResourceManagerC.byusingOracleLabelSecurityoptionsD.byassigningaprofi

6、letotheuserCorrectAnswer:DSection:(none)【CUUG内部资料】OCP讨论群：1015267481Explanation验证过QUESTION3AsauseroftheORCLdatabase,youestablishadatabaselinktotheremoteHQdatabasesuchthatallusersintheORCLdatabasemayaccesstablesonlyfromtheSCOTTschemaintheHQdatabase.SCOTT'spasswordisTIGER.Theservicemane"H

7、Q"isusedtoconnecttotheremoteHQdatabase.Whichcommandwouldyouexecutetocreatethedatabaselink?A.CREATEDATABASELINKHQUSING'HQ';B.CREATEDATABASELINKHQCONNECTTOCXJRRENT_USERUSINGHQ'SC.CREATEPUBLICDATABASELINKHQCONNECTTOscottIDENTIFIEDBYtigerUSING'HQ';D.CREATEDATABASELINKHQCONNECTTOscottIDEN