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

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

2、ngamultitenantcontainerdatabasewiththreepluggabledatabaseA.Alladministrationtasksmustbedonetoaspecificpluggabledatabase.B.Thepluggabledatabasesincreasepatchingtime.C.Thepluggabledatabasesreduceadministrationefft.D.Theplu

3、ggabledatabasesarepatchedtogether.E.Pluggabledatabasesareonlyusedfdatabaseconsolidation.CrectAnswer:CEQUESTION32Examinethecurrentvaluefthefollowingparametersinyourdatabaseinstance:SGA_MAX_SIZE=1024MSGA_TARGET=700MDB_8K_C

4、ACHE_SIZE=124MLOG_BUFFER=200MYouissuethefollowingcommtoincreasethevalueofDB_8K_CACHE_SIZE:SQLALTERSYSTEMSETDB_8K_CACHE_SIZE=140MWhichstatementistrueA.ItfailsbecausetheDB_8K_CACHE_SIZEparametercannotbechangeddynamically.B

5、.ItsucceedsonlyifmemyisavailablefromtheautotunedcomponentsifSGA.C.ItfailsbecauseanincreaseinDB_8K_CACHE_SIZEcannotbeaccommodatedwithinSGA_TARGET.D.ItfailsbecauseanincreaseinDB_8K_CACHE_SIZEcannotbeaccommodatedwithinSGA_M

6、AX_SIZE.CrectAnswer:BQUESTION33Whichthreestatementsaretrueconcerningunpluggingapluggabledatabase(PDB)A.ThePDBmustbeopeninreadonlymode.B.ThePDBmustbeclosed.C.TheunpluggedPDBbecomesanonCDB.D.TheunpluggedPDBcanbepluggedinto

7、thesamemultitenantcontainerdatabase(CDB)E.TheunpluggedPDBcanbepluggedintoanotherCDB.F.ThePDBdatafilesareautomaticallyremovedfromdisk.CrectAnswer:BDE【CUUG內(nèi)部資料】OCP討論群：1015267481tableintheHRschemabyissuingthefollowingcomm:$

8、sqlldrhrhr@pdbtable=employeesWhichtwostatementsaretrueregardingthecommA.ItsucceedswithdefaultsettingsiftheEMPLOYEEStablebelongingtoHRisalreadydefinedinthedatabase.B.ItfailsbecausenoSQLLoaderdatafilelocationisspecified.C.

9、ItfailsiftheHRuserdoesnothavetheCREATEANYDIRECTYprivilege.D.ItfailsbecausenoSQLLoadercontrolfilelocationisspecified.CrectAnswer:ACSection:(none)Explanation：sqlldrhrhrtable=employees能夠執(zhí)行，會(huì)默認(rèn)找employees.dat文件，然后臨時(shí)創(chuàng)建一個(gè)direct

10、y，如果沒有權(quán)限，會(huì)報(bào)如下錯(cuò)誤：SQLLoader816:errcreatingtemparydirectyobjectSYS_SQLLDR_XT_TMPDIR_00000ffileemployees.datQUESTION37AfterimplementingfullacleDataRedactionyouchangethedefaultvalueftheNUMBERdatatypeasfollows:Afterchangingthe

11、valueyounoticethatFULLredactioncontinuestoredactnumericdatawithzero.（您注意到FULL編校繼續(xù)以零編校數(shù)值數(shù)據(jù)）也就是上面的修改還沒有生效，該命令是把number的數(shù)據(jù)類型編輯以后默認(rèn)值為－1）。WhatmustyoudotoactivatethenewdefaultvaluefnumericfullredactionA.Reenableredactionpolicie

12、sthatuseFULLdataredaction.B.RecreateredactionpoliciesthatuseFULLdataredaction.C.Reconnectthesessionsthataccessobjectswithredactionpoliciesdefinedonthem.D.Flushthesharedpool.E.Restartthedatabaseinstance.CrectAnswer:ESecti

13、on:(none)Explanation：（解析：這道題題目比較難理解，甲骨文在acle數(shù)據(jù)庫12c中加入了數(shù)據(jù)校訂作為一個(gè)新的安全特性。acleDataRedaction（acle數(shù)據(jù)校訂）提供了一個(gè)有效且易于實(shí)現(xiàn)的方法來屏蔽敏感信息。該工具能夠?qū)崟r(shí)地從數(shù)據(jù)校訂得出的查詢結(jié)果會(huì)返回到它們原來的應(yīng)用程序。DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES—更改完全編輯的默認(rèn)返回值。必須重啟數(shù)據(jù)庫才能生效。）