OCP考试052最新考试题库原题-6-20180615

《OCP考试052最新考试题库原题-6-20180615》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、052题库解析最新15道题052-题库解析-6-20180615题库新特点：l更加灵活，题库的顺序与考试时的顺序每场都在变化l更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案l不断有新的考题出现，目前最新已经更新到130道题每周五晚8点-直播地址：ke.qq.com/course/326223ocp考试讨论群：836361015验证：ocpCUUG整理，官网：www.cuug.com1、Whichtwocanbeconfiguredwithprofiles?•A.tablespace

2、quotasforusers•B.thetimeafterwhichanidlesessionisterminated •C.defaulttablespaceforusers•D.defaultobjectprivilegesforusers •E.sessionCPUlimits•F.defaultsystemprivilegesforusers •CorrectAnswer:BE2、InwhichstatemustadatabasebetoenableARCHIVELOG? •A.NOMOU

3、NT•B.OPENinRESTRICTEDmode •C.OPENinREADWRITEmode •D.MOUNT•E.OPENinREADONLYmode •CorrectAnswer:D3、YourdatabaseisopeninARCHIVELOGmode.LOG_ARCHIVE_DESTissettoFastRecoveryArea(FRA)anditis100%fullwhen alogswitchtakesplace.Noalternativeoroptionalarchivedest

4、inationsaredefined. Whatistheoutcome?•A.Obsoletebackupsareautomaticallydeletedandnowarchivelogsaregenerated.•B.Thearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceisavailable,nowarchivelogsaregenerated.•C.Noarchivelogsaregenerated.•D.Alla

5、ctivesessionsaredisconnectedandtheirtransactionsrolledback.•E.Allactivesessionshanguntilthedatabaseadministrator(DBA)makesspaceavailableintheFRA.•CorrectAnswer:E4、WhichthreearetrueaboutOracledatabasesecurity?•A.Bydefault,SYSDBAconnectionshaveaccesstoa

6、llschemaobjects. •B.SYSDBAconnectionsarealwayssubjecttomandatoryauditing. •C.Bydefault,SYSOPERconnectionshaveaccesstothedatadictionary. •D.FineGrainedAuditingcanbeusedtorestrictaccesstosensitivedata. •E.SYSOPERconnectionsarealwayssubjecttomandatoryaud

7、iting.•F.MandatoryauditingisenabledbysettingAUDIT_SYSOPERATIONStoTRUE.•CorrectAnswer:ABE5.Whichthreestructurescanspanmultipledatafiles?•A.chainedrows•B.segments•C.temporarysegmentextents •D.indexextents•E.tableextents•F.migratedrows•CorrectAnswer:ABF6

8、、ExaminetheseSQLstatementsandtheiroutput:A.Inactiveundowillneverberetainedformorethan15minutes. B.Theundotablespacecangrowautomaticallyifthereisnotenoughspaceto retainactiveundo.C.Inactiveundowillberetainedaslongaspossiblewithinthelimitsofthec