OCP052最新考试题库考试原题30525.docx

OCP052最新考试题库考试原题30525.docx

《OCP052最新考试题库考试原题30525.docx》由会员分享，可在线阅读，更多相关《OCP052最新考试题库考试原题30525.docx（6页珍藏版）》请在冰豆网上搜索。

OCP052最新考试题库考试原题30525

052题库解析

最新15道题

052-题库解析-3-20180525

题库新特点：

更加灵活，题库的顺序与考试时的顺序每场都在变化

更加考验知识点的掌握，题库答案为二，考试时要求选择

最佳一个答案

不断有新的考题出现，目前最新已经更新到130道题

每周五晚8点-直播地址：

ocp考试讨论群：

836361015验证：

ocp

CUUG整理，官网：

•1、WhichtwoeventsalwaysrequesttheLGWRtowrite?

•❑A）whenLGWRisnotifiedbyaserverprocessthatperforms

aCommitorROLLBACK

•❑B）WhenPMONrestartsaserverprocess•❑C）whenDBWnwritesdirtybuffers•❑D）whenalogswitchoccurs•❑E）whenacheckpointoccurs•Answer:

CD

•2、Examinethesecommandsandtheiroutput:

•SQL>SELECT*FROMemp;

•ENONAME

•---------

•100Adam

•101Alan

•SQL>INSERTINTOempVALUES（102,'Ben"）;•1rowcreated.•SQL>COMMIT;

•Commitcompleted.

•SQL>UPDATEempSETename='Bryan'WHEREeno=102;•1rowupdated.

•Apowerfailureoccurs.TheInstanceIsrestartedandthisqueryIsexecuted.•SQL>SELECTenameFROMemp;

•WhatIstheoutcome?

•❑A）OnlyAdamandAlanaredisplayed.•❑B）OnlyAdam,Alan,andBryanaredisplayed.•❑C）Adam,Alan,Ben,andBryanaredisplayed.•❑D）Norowsarereturned.

•❑E）OnlyAdam,Alan,andBenaredisplayed.•Answer:

E

•3、WhereIsbackupmetadatastoredforusebyRecovery

Manager（RMAN）?

•❑A）Inthecontrolfile•❑B）IntheSYSAUXtablespace•❑C）intheSPFILE

•❑D）intheSYSTEMtablespace•❑E）Inthediagnosticdestinationflies•Answer:

A

•4、WhichtwocanbebackedupbyusingRMANwhenadatabaseIsopeninARCHIVELOGmode,sothatmediarecoverycanbeperformedIfrequired?

•❑A）controlfiles•❑B）passwordfile•❑C）pfile

•❑D）onlineredologs•❑E）flashbacklogs•❑F）datafiles

•Answer:

AF

5、YourdatabaseisusingAutomaticMemoryManagement.WhichtwoSGAcomponentsmustbemanagedmanually?

•❑A）defaultbuffercache

•❑B）redologbuffer•❑C）largepool

•❑D）sharedpool

•❑E）keepbufferpool•Answer:

BE

6、Whichtwoaretrueaboutroles?

•❑A）Arolecanbegrantedacombinationofsystemandobject

privilegesandotherroles.

•❑B）TheCONNECTroleIsgrantedautomaticallytoauser

whenItIscreated.

•❑C）RolesareownedbySYSTEM.

•❑D）TheRESOURCEroleIsgrantedtheCREATESESSION

privilege.

•❑E）AsecureapplicationrolecanbesetonlybyItsassociated

PL/SQLpackage.

•Answer:

AE

7、USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPtoUSER2.

SYSexecutesthiscommand:

SQL>REVOKEUPDATEONuser1.empFROMuser1;Whatwillbetheoutcome?

•❑A）ItwillsucceedandonlyUSER2willbeunabletoperformSELECT,

INSERT,OrUPDATEonUSER1.EMU.

•❑B）ItwillsucceedandonlyUSER1willbeunabletoperformSELECT,

INSERT,OrUPDATEonUSER1.EMP.

•❑C）ItwillsucceedbutneitherUSER1norUSER2willbeabletoperform

SELECT,INSERT,orUPDATEonUSER1.EMP.0

•❑D）ItwillfallbecauseUSER1IstheownerofUSER1.EMP.

•❑E）ItwillsucceedandneitherUSER1norUSER2willbeabletoperformINSERTorUPDATEonUSER1.EMP,butbothwillbeabletoqueryUSER1.EMP）.

•Answer:

D

8、WhichthreearetrueabouttheAutomaticDatabaseDiagnosticMonitor（ADDM）?

•❑A）ItsfindingsareaccessibleonlybyusingOracleEnterprise

Manager.

•❑B）Itimprovesdatabaseperformancebyautomatically

implementingOracle'sbestpractices.

•❑C）ItcanassisttheDBAindiagnosingdatabaseinstance

startupfailures.

•❑D）ItcanbeusedbyexecutingthePL/SQLproceduresinthe

DBMS_ADDMpackage.

•❑E）ItrunsautomaticallyaftereachAutomaticWorkload

Repositorysnapshotiscreated.

•❑F）Itprovidesrecommendationstoimprovedatabase

performance.

•Answer:

DEF

9、Examinethesecomponents:

•1.Executionplanforanon-embeddedSQLstatement•2.Local,global,andpackagevariablesforasession

•3.ExecutionplanforaSQLstatementcontainedInaPL/SQL

programunit

•4.ResultsofexecutedqueriesandqueryfragmentsS.PL/SQL

functionresultsets

•WhichofthesearestoredinthesharedSQLarea?

•❑A）1and4

•❑B）1,2and3•❑C）1and3

•❑D）1,3,4,and5•Answer:

C

•10、ExaminethisLISTENER.ORAfile:

•LISTENER=

•（DESCRIPTION_LIST=•（DESCRIPTION=•（ADDRESS_LIST=

•（ADDRESS=（PROTOCOL=TCP）（HOST=）（PORT=1522））•）））

•SIDLISTLISTENER=•（SIDLIST=

•（SID_DESC=

•（GLOBAL_DBNAME=）

•（ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1）•（SID_NAME=orcl）

•））

•HowshouldyouconfigureanadditionallistenerLISTENER2thatlistensforthesameSID?

•❑A）AddrelevantdetailsInDESCRTPTIONundertheexistingLTRTENERwithadifferentport

numberinLISTENER.ORA.

•❑B）CreateanotherconfigurationfilecalledLISTENER2.ORAwithonlyLISTENER2detailsinit.•❑C）AddrelevantdetailsinSID_LIST_LISTENERundertheexistingLISTENERinLISTENER.ORA•❑D）AddLISTENER2anditsSID_LISTdetailsseparatelyunderthenameLISTENER2in

LISTENER.ORA

•Answer:

D

11、YourdatabaseIsopeninARCHIVELOGmode.

•LOG_ARCHIVE_DESTIssettoFastRecoveryArea（FRA）anditIs100%full

whenalogswitchtakesplace.

•Noalternativeoroptionalarchivedestinationsaredefined.•WhatIstheoutcome?

•❑A）Allactivesessionsaredisconnectedandtheirtransactionsrolledback.•❑B）Thearchivelogentriesaremadeinthediagnosticdestinationand

whenspaceIsavailable,newarchivelogsaregenerated.

•❑C）Noarchivelogsaregenerated.

•❑D）Obsoletebackupsareautomaticallydeletedandnewarchivelogsare

generated.

•❑E）Allactivesessionshanguntilthedatabaseadministrator（DBA）makes

spaceavailableIntheFRA.

•Answer:

E

12、Whichtwoaretrueaboutdatadictionaryviews?

•❑A）ALLorUSERprefixedviewsdisplayoutputthatare

subsetsoftheoutputfromtheDBAprefixeddataviews.

•❑B）DBAprefixedviewsareaccessiblewhenadatabaseisIn

mountstate.

•❑C）Ausermaynotnecessarilybetheownerofallobjects

thatcanbeviewedbyusingtheALLprefixedviews.

•❑D）AusercanquerytheDBAprefixedviewsonlyiftheyhave

theSYSDBAprivilege

•❑E）AlldatadictionaryviewsareprefixedwithDBA.OrALLor

USER

•Answer:

AD

13、USER1.EMPhasareferentialIntegrityconstraintdefinedonEMP.DNOthatreferencesUSER1.DEPT.DNO.

•user1executesthesecommands:

•SQL>UPDATEdeptSET1oc=’UK’wheredno=1;•1rowupdated

•SQL>UPDATEempSETsal=1000whoreeno=100;•1rowupdated

•SQL>ALTERTABLEdeptDROP（dno）;•Whatwillbetheoutcomeandwhy?

•❑A）ItwillfailbecauseareferentialIntegrityconstraintIsdefinedonUSER1.EMP.•❑B）ItwillfallbecausethereIsanuncommittedtransactiononUSER1.EMP.•❑C）ItwillfailbecausethereisanuncommittedtransactiononUSER1.DEPT.•❑D）ItwillexecutesuccessfullyanddropDEPT.DNO.

•❑E）ItwillexecutesuccessfullyanddroptheDEPT.DNOandEMP.DNOcolumns.•Answer:

A

14、Whichtwoaretrueaboutundotablespaces?

•❑A）Theyalwaysretainundoforthetimeperioddefinedby

UNDO_RETENTION.

•❑B）Theymusthaveonlyonedatafile.

•❑C）TheycanberecoveredonlywhenanInstanceIsIn

MOUNTstate.

•❑D）TablescanbecreatedInundotablespacesbySYS.

•❑E）Single-Instancedatabasescanhaveonlyoneactiveundo

tablespace.

•Answer:

CE

15、WhichfouraretrueaboutthetoolsusedtoadministerOracledatabases?

•❑A）SQL*Pluscanbeusedtocreatedatabases.•❑B）RMANcanbeusedtostartupOracleInstances.•❑C）DBCAcanbeusedtoupgradedatabases.

•❑D）TheDataPumputilitycanbeusedtoloaddatafromtext

files.

•❑E）SQL*PluscanbeusedtostartupOracleinstances.•❑F）SRVCTLcanbeusedtoshutdownOracleinstances.•Answer:

ABEF