OCP考试052最新考试题库原题60615.docx
- 文档编号:2403228
- 上传时间:2022-10-29
- 格式:DOCX
- 页数:5
- 大小:28.26KB
OCP考试052最新考试题库原题60615.docx
《OCP考试052最新考试题库原题60615.docx》由会员分享,可在线阅读,更多相关《OCP考试052最新考试题库原题60615.docx(5页珍藏版)》请在冰豆网上搜索。
OCP考试052最新考试题库原题60615
052题库解析
OCP考试052最新考试题库原题-6-20180615
题库新特点:
更加灵活,题库的顺序与考试时的顺序每场都在变化
更加考验知识点的掌握,题库答案为二,考试时要求选择
最佳一个答案
不断有新的考题出现,目前最新已经更新到130道题
1、Whichtwocanbeconfiguredwithprofiles?
•A.tablespacequotasforusers
•B.thetimeafterwhichanidlesessionisterminated•C.defaulttablespaceforusers
•D.defaultobjectprivilegesforusers•E.sessionCPUlimits
•F.defaultsystemprivilegesforusers•CorrectAnswer:
BE
2、InwhichstatemustadatabasebetoenableARCHIVELOG?
•A.NOMOUNT
•B.OPENinRESTRICTEDmode•C.OPENinREADWRITEmode•D.MOUNT
•E.OPENinREADONLYmode•CorrectAnswer:
D
3、YourdatabaseisopeninARCHIVELOGmode.
LOG_ARCHIVE_DESTissettoFastRecoveryArea(FRA)anditis100%fullwhenalogswitchtakesplace.
Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoutcome?
•A.Obsoletebackupsareautomaticallydeletedandnowarchivelogsare
generated.
•B.Thearchivelogentriesaremadeinthediagnosticdestinationandwhen
spaceisavailable,nowarchivelogsaregenerated.
•C.Noarchivelogsaregenerated.
•D.Allactivesessionsaredisconnectedandtheirtransactionsrolledback.•E.Allactivesessionshanguntilthedatabaseadministrator(DBA)makes
spaceavailableintheFRA.
•CorrectAnswer:
E
4、WhichthreearetrueaboutOracledatabasesecurity?
•A.Bydefault,SYSDBAconnectionshaveaccesstoallschemaobjects.•B.SYSDBAconnectionsarealwayssubjecttomandatoryauditing.•C.Bydefault,SYSOPERconnectionshaveaccesstothedatadictionary.•D.FineGrainedAuditingcanbeusedtorestrictaccesstosensitivedata.•E.SYSOPERconnectionsarealwayssubjecttomandatoryauditing.
•F.MandatoryauditingisenabledbysettingAUDIT_SYSOPERATIONSto
TRUE.
•CorrectAnswer:
ABE
5.Whichthreestructurescanspanmultipledatafiles?
•A.chainedrows
•B.segments
•C.temporarysegmentextents•D.indexextents
•E.tableextents
•F.migratedrows
•CorrectAnswer:
ABF
6、ExaminetheseSQLstatementsandtheiroutput:
A.Inactiveundowillneverberetainedformorethan15minutes.B.Theundotablespacecangrowautomaticallyifthereisnotenoughspacetoretainactiveundo.
C.Inactiveundowillberetainedaslongaspossiblewithinthelimitsofthecurrentsizeoftheundotablespace.
D.Inactiveundowillalwaysberetainedforatleast15minutes.E.Activeundowillberetainedaslongasneededbytransactions.CorrectAnswer:
BE
•7
WhichthreecanreducelockcontentioninanOracledatabase?
A.TheDatabaseResourceManagerB.profiles
C.schedulingOLTPandbatchworkloadsatdifferenttimesD.manuallockingofdatabaseobjectsforDMLstatementsE.committingtransactionsinatimelymannerCorrectAnswer:
CDE
8、WhichtwoaretrueabouttheInventorydirectory?
•A.Itisownedbytheoinstallgroup,whichmustbecreated
beforeinstallingOraclesoftwareforthefirsttimeonaserver.
•B.ItissharedbyallOraclesoftwareinstallationsonasingle
server.
•C.ItshouldbecreatedbeforeinstallingOraclesoftwareforthe
firsttimeonaserver.
•D.ItisrequiredonlyforOracleGridInfrastructureandOracle
Databasesoftwareinstallations.
•E.ItcanbecreatedonlyiftheORACLE_BASEenvironment
variableisset.
•CorrectAnswer:
AB
9、Whichistrueaboutunusableindexes?
•A.Rebuildinganunusableindexalwaysrequiresatleasttwice
thespaceoftheoriginalindex
•B.RebuildinganunusableindexalwaysallowsDMLstatements
ontheindex’stableduringtherebuild.
•C.Rebuildingoccursautomaticallywhenanunusableindexis
chosenbytheoptimizerwhencreatinganexecutionplan
•D.Rebuildinganunusableindexcreatesanewsegmentafter
droppingtheunusableindex.
•CorrectAnswer:
D
10、Whichtwoaretrueaboutspacemanagementintablespaces?
•A.Freelistsareusedformanagingfreespaceforsegmentsin
locallymanagedtablespaces.
•B.Extentallocationmustbespecifiedasautomaticfor
automaticsegmentspacemanagement(ASSM)tablespaces.
•C.ASSMtablespacespreventrowchaining.
•D.Locallymanagedtablespacestrackadjacentfreespace
automaticallybyusingbitmaps.
•E.LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement(MSSM),andallthesegmentsinthesetablespacesaremanagedonewayortheother.
•CorrectAnswer:
DE
11、Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?
•A.CROSSCHECKBACKUP•B.REPORTOBSOLETE•C.LISTEXPIREDBACKUP•D.SHOWDATAFILEBACKUPCOPIES•Answer:
B
12TableEMPresidesintheUSERStablespace.Examinethiscommand:
SQL>DROPTABLEempPURGE;
WhichtwomethodswouldyouusetorecoverEMP?
•A.FlashbackDrop
•B.re-creatingthetableandreinsertingtherows•C.performingatablespacepointintimerecoveryofUSERS•D.FlashbackTransactionBackout
•E.FlashbackTable•Answer:
BC
12WhichistrueaboutenablingAUTOEXTENDfordatafiles?
•A.Itcanbeenabledfordatafilesonlyinsmallfiletablespaces.•B.Itcanbeenabledforanexistingdatafileinatablespaceby
usingtheALTERTABLESPACEcommand.
•C.Itcanbeenabledonlyfordatafilesinnon-OMFtablespaces.•D.Itcanbeenabledfordatafilesonlyinbigfiletablespaces.
•E.Itcanbeenabledforanewdatafilethatisaddedtoatablespaceonlyiftheexistingdatafilesinthattablespacehaveautoextendenabled.
•Answer:
B
13Inoneofyourdatabases:
••Thedatabasedefaulttablespace
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OCP 考试 052 最新 题库 60615