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

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

2、rdatabaseinstance:NAMETYPEVALUEundo_managementstringAUTOundo_retentioninteger1200undo_tablespacestringUNDOTBS1Youexecutethefollowingcomm:SQLALTERTABLESPACEundotbs1RETENTIONNOGUARANTEEWhichstatementistrueinthisscenarioA.U

3、ndodataiswrittentoflashbacklogsafter1200seconds.B.Inactiveundodataisretainedf1200secondsevenifsubsequenttransactionsfailduetolackofspaceintheundotablespace.C.YoucanperfmaFlashbackDatabaseoperationonlywithinthedurationof1

4、200seconds.D.Anattemptismadetokeepinactiveundof1200secondsbuttransactionsmayoverwritetheundobefethattimehaselapsed.CrectAnswer:DSection:(none)Explanation驗證過QUESTION2Auserestablishesaconnectiontoadatabaseinstancebyusingan

5、acleconnection.Youwanttoensurethefollowing:1.Theuseraccountmustbelockedafterfiveunsuccessfulloginattempts.2.Datareadpersessionmustbelimitedftheuser.3Theusercannothavemethanthreesimultaneoussessions.4.Theusermusthaveamaxi

6、mumof10minutessessionidletimebefebeingloggedoffautomatically.HowwouldyouaccomplishthisA.bygrantingasecureapplicationroletotheuserB.byimplementingDatabaseResourceManagerC.byusingacleLabelSecurityoptionsD.byassigningaprofi

7、letotheuserCrectAnswer:DSection:(none)【CUUG內部資料】OCP討論群：1015267481YouplantocreateadatabasebyusingtheDatabaseConfigurationAssistant(DBCA)withthefollowingspecifications:Applicationswillconnecttothedatabaseviaadletier.?Thenu

8、mberofconcurrentuserconnectionswillbehigh.?ThedatabasewillhavemixedwkloadwiththeexecutionofcomplexBIqueriesscheduledatnight.WhichDBCAoptionmustyouchoosetocreatethedatabaseA.aGeneralPurposedatabasetemplatewithdefaultmemya

9、llocationB.aDataWarehousedatabasetemplatewiththededicatedservermodeoptionAMMenabledC.aGeneralPurposedatabasetemplatewiththesharedservermodeoptionAutomaticMemyManagement(AMM)enabledD.adefaultdatabaseconfigurationCrectAnsw

10、er:CSection:(none)ExplanationExplanationReference:QUESTION6WhichtwostatementsaretrueaboutthelogicalstagestructureofanacledatabaseA.Anextentcontainsdatablocksthatarealwaysphysicallycontiguousondisk.B.Anextentcanspanmultip

11、lesegmentsC.Eachdatablockalwayscrespondstooneoperatingsystemblock.D.Itispossibletohavetablespacesofdifferentblocksizes.E.AdatablockisthesmallestunitofIOindatafiles.CrectAnswer:DEQUESTION7Whichtwostatementscrectlydescribe

12、therelationshipbetweendatafileslogicaldatabasestructuresA.Asegmentcannotspandatafiles.B.Adatafilecanbelongtoonlyonetablespace.C.Anextentcannotspandatafiles.D.Thesizeofanacledatablockinadatafileshouldbethesameasthesizeofa