51CTO首页
内容精选
博客
学堂
精培
企业培训
CTO训练营
智能汽车
开源基础软件社区
WOT全球技术创新大会
公众号矩阵
移动端
短视频 免费课程 课程排行 直播课 软考学堂
精品班 厂商认证 IT技术 2023年软考 PMP项目管理
在线学习 企业服务
CTO训练营 技术经理研习营 LeaTech峰会
文章 资源 问答 开源课堂 专栏 直播
51CTO
开源基础软件社区
51CTO技术栈
51CTO官微
51CTO学堂
51CTO博客
CTO训练营
开源基础软件社区订阅号
51CTO学堂APP
51CTO学堂企业版APP
开源基础软件社区视频号
# 2018 ocp 11g

CP-052考试题库汇总（56）-CUUG内部解答版

Examinethefactsaboutadatabase:1.USERSisthedatabasedefaulttablespace.2.USER1,USER2,andUSER3havetheCREATESESSIONprivilege.3.TheyalsohaveUNLIMITEDQUOTAonthedefaulttablespaceUSERS.4.Theyhavenootherprivile

oracle
ocp
cuug
052
原创 2019-09-18 15:01:24 532 阅读

OCP-052考试题库汇总（55）-CUUG内部解答版

Examinethesefactsaboutadatabase:1.USERisthedatabasedefaulttablespace.2.USER1,USER2,andUSER3havetheCREATESESSIONprivilege.3.TheyalsohaveUNLIMITEDQUOTAonthedefaulttablespaceUSERS.4.Theyhavenootherprivil

oracle
ocp
cuug
052
原创 2019-09-18 13:29:56 293 阅读

OCP-052考试题库汇总（54）-CUUG内部解答版

USER1grantsSELECTandUPDATEprivilegesonUSER1.EMPtoUSER2。SYSexecutesthiscommand：SQL>REVOKESELECTONuser1.empFROMuser1;Whatwillbetheoutcome?A)ItwillsucceedandUSER2willbeunabletoperformSELECTonUSER1.EMP

oracle
ocp
cuug
052
原创 2019-09-11 10:47:52 493 阅读 1评论

OCP-052考试题库汇总（53）-CUUG内部解答版

USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPtoUSER2.Sysexecutesthiscommand:SQL>REVOKEUPDATEONuser1.empFROMuser1;Whatwillbetheoutcome?A)ItwillfailbecauseUSER1istheownerofUSER1.EMP.B)Itwil

oracle
ocp
cuug
052
原创 2019-09-10 13:03:16 386 阅读

OCP-052考试题库汇总（52）-CUUG内部解答版

YourDB_RECOVERY_FILE_DEST_SIZEIS8G,Currently,5Gofthespaceisusedofwhich4Gconsistsofobsoletebackups,Youexecutethiscommand;SQL>ALTERSYSTEMSETdb_recovery_file_dest_size=2G;Whatistheoutcome?A)ItchangesD

oracle
ocp
cuug
052
原创 2019-09-10 09:27:57 385 阅读

OCP-052考试题库汇总（51）-CUUG内部解答版

Yourdatabaseisopeninarchivemode.LOG_ARChivE_DESTissettoFastRecoveryArea(FRA)andItis100%fullwhenalogswitchtakesplace.Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoutcome?A)Obsoleteback

oracle
ocp
cuug
052
原创 2019-09-09 13:17:29 344 阅读

OCP-052考试题库汇总（50）-CUUG内部解答版

WhichtwoaretrueabouttheFastRecoveryArea(FRA)?A)Itshouldbelargerthanthedatabase.B)OnlyconsistentbackupscanbestoredintheFRA.C)SpacemanagementintheFRAisinfluencedbythedatabasebackupretentionpolicy.D)Itmu

oracle
ocp
cuug
052
原创 2019-09-09 11:38:16 354 阅读

OCP-052考试题库汇总（49）-CUUG内部解答版

WhichtwostatementsaretrueabouttheAutomaticDiagnosticRepository(ADR)?A)ItonlyexistsifDIAGNOSTIC_DESTisconfiguredintheSPFILE.B)Itincludesdiagnosticdataforcriticalerrorsforbackgroundprocesses.C)Itonlycon

oracle
ocp
cuug
052
原创 2019-09-04 16:30:47 313 阅读

OCP-052考试题库汇总（48）-CUUG内部解答版

WhichistrueabouttheAutomaticDiagnosticRepository(ADR)?A)ItisusedonlyiftheDIAGNOSTIC_DESTparameterismanuallyconfigured.B)Itonlycontainsthealertlogandtracefilesforbackgroundprocesses.C)Itslocationisalwa

oracle
ocp
cuug
052
原创 2019-09-04 15:34:36 257 阅读

OCP-052考试题库汇总（47）-CUUG内部解答版

WhichthreearetrueabouttheAutomaticDatabaseDiagnosticMonitor(ADDM)?A)ItimprovesdatabaseperformancebyautomaticallyimplementingOracle‘sbestpractices.B)ItcanassisttheDBAindiagnosingdatabaseinstancestartup

oracle
ocp
cuug
052
原创 2019-08-30 14:39:20 322 阅读

OCP-052考试题库汇总（46）-CUUG内部解答版

Examinethiscommand:SQL>CREATEGLOBALTEMPORARYTABLEreport_work_area(startdateDATE,enddateDATE,classCHAR(20))ONCOMMITPRESERVEROWS;WhichthreestatementsaretrueaboutrowsinsertedintoREPORT_WORK_AREA?A)Row

oracle
ocp
cuug
052
原创 2019-08-29 13:24:33 392 阅读

OCP-052考试题库汇总（45）-CUUG内部解答版

Youwanttoaccessemployeedetailscontainedinflatfilescreatedbyanapplication.Whichtwomethodswillachievethis?A)UseaBFILEcolumninatabletoaccesstheflatfile.B)UseanOracleLoadertypeExternaltable.C)UseanOracleD

oracle
ocp
cuug
052
原创 2019-08-28 13:27:10 338 阅读

OCP-052考试题库汇总（44）-CUUG内部解答版

Whichtwoaretrueaboutexternaltables?A)TheycanbestoredinanASMClusterFileSystem(ACFS).B)TheycanalwaysbeupdatedusingSQL.C)TheysupporttheORACLE_DATAPUMPaccessdriver.D)Theyhaveextents.E)TheysupportallDMLope

oracle
ocp
cuug
052
原创 2019-08-28 11:32:11 366 阅读

OCP-052考试题库汇总（43）-CUUG内部解答版

Whichistrueaboutexternaltables?A)Segmentsareallocatedforexternaltables.B)Theymayhaveindexes.C)Theydonotsupportpartitioning.D)TheORACLE_DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables.E)DMLope

oracle
ocp
cuug
052
原创 2019-08-23 13:43:48 376 阅读

OCP-052考试题库汇总（42）-CUUG内部解答版

Yousuccessfullyexecutedthesecommands:connectscott/tiger@prod1;CREATEDATABASELINKdb_prod2CONNECTTOscottIDENTIFIEDBYtigerUSING'PROD2';Whichtypeofdatabaselinkiscreated?A)privatecurrentuserdatabas

oracle
ocp
cuug
052
原创 2019-08-22 14:19:52 419 阅读

OCP-052考试题库汇总（41）-CUUG内部解答版

Examinethissessionoutput:SQL>connectscott/tigerConnected.SQL>selectname,value2fromv$parameter3wherename='audit_trail';NAMEVALUEaudit_trailDBSQL>auditallonemp;Auditsucceeded.Whichtwowi

oracle
ocp
cuug
052
原创 2019-08-22 13:32:04 269 阅读

OCP-052考试题库汇总（40）-CUUG内部解答版

Whichfouraretrueaboutauditing?A)DMLstatementscanbeauditedwhentheyfailtoexecuteB)Selectstatementscanbeauditedwhentheyexecutesuccessfully.C)AllOracleauditingoperationsoccurbydefault.D)NoOracleauditingop

oracle
ocp
cuug
052
原创 2019-08-21 15:35:17 255 阅读

OCP-052考试题库汇总（39）-CUUG内部解答版

Whichthreearetrueaboutauditing?A)AuditingisactiveonlywhenthedatabaseisOPEN.B)Auditrecordsarealwaysstoredinthedatabase.C)Auditoftheuseofsystemprivilegescanbeenabledforindividualdatabaseusers.D)DDLstate

oracle
ocp
cuug
052
原创 2019-08-21 14:14:57 293 阅读

OCP-052考试题库汇总（38）-CUUG内部解答版

YouwanttoauditupdatestatementsthatrefertoUSER1.DEPT.DNAME.Whichtypeofauditingmustyouuse?A)standardauditingB)mandatoryauditingC)value-basedauditingD)fine-grainedauditingAnswer:D赵：Fine-GrainedAudit(FGA)

oracle
ocp
cuug
052
原创 2019-08-20 10:31:06 288 阅读

OCP-052考试题库汇总（37）-CUUG内部解答版

ExaminethesefactsaboutobjectsintheSYSTEMschema:1.EMPisatable.2.EMP_PKisaprimarykeyconstraintonEMP.ENO.3.EMP_IDXisanindexonEMP.MGR_NO.4.EMP_SEQisasequenceusedtogeneratevaluesforEMP.ENO.5.EMP_OPS_PKGisa

oracle
ocp
cuug
052
原创 2019-08-20 09:18:07 348 阅读

OCP-052考试题库汇总（36）-CUUG内部解答版

WhichtwostatementsaretrueregardingtheOracleDataPumpexportandimportoperations?(choosetwo)A)Youcannotexportdatafromaremotedatabase.B)Youcanrenametablesduringanimportoperation.C)Youcanoverwriteexistingdu

oracle
ocp
cuug
052
原创 2019-08-19 13:18:06 424 阅读

OCP-052考试题库汇总（35）-CUUG内部解答版

WhichtwoaretrueaboutOracleDataPumpinOracleDatabase11gRelease2?A)Ifthedirectoryusedintheexportoperationhasexistingdumpfiles,itoverwritesthem.B)Itallowsencryptiontobeperformedwithoutusingapassword.C)Its

oracle
ocp
cuug
052
原创 2019-08-19 10:07:16 351 阅读

OCP-052考试题库汇总（34）-CUUG内部解答版

Whereisanexpdpoperationtracked?A)dumpfilesB)controlfileC)logfilesD)AutomaticDiagnosticRepository(ADR)E)mastertable(MT)Answer:E赵：题译：哪里有一个Exdp操作跟踪?Mastertable是一个临时table，专门为importpump和exportpump创建的，一旦完成就

oracle
ocp
cuug
052
原创 2019-08-15 16:20:11 414 阅读

OCP-052考试题库汇总（33）-CUUG内部解答版

Whichtwocanbeexportedbyanon-administrativeaccountbyusingDataPump?A)directoryobjectsB)tablesC)tablespacesD)schemasE)databaseAnswer:BD赵：EXP和IMP是客户端工具程序，它们既可以在客户端使用，也可以在服务端使用。EXPDP和IMPDP是服务端的工具程序，他们只能在OR

oracle
ocp
cuug
052
原创 2019-08-15 15:36:12 282 阅读

OCP-052考试题库汇总（32）-CUUG内部解答版

WhichstatemustadatabasebetoenableARCHIVELOG?A)NOMOUNTB)OPENINREADWRITEmodeC)OPENINREADONLYmodeD)OPENINRESTRICTEDmodeE)MOUNTAnswer:E赵：题译：数据库必须是哪个状态才能启用ARCHIVELOG?oracle启动分为三步：nomount--根据参数文件启动实例(instan

ocp
cuug
oracle
052
原创 2019-08-14 14:52:37 255 阅读

OCP-052考试题库汇总（31）-CUUG内部解答版

whichfouraretrueaboutthetoolsusedtoadministerOracledatabase?A)theDataPumputilitycanbeusedtoloaddatafromtextfiles.B)SRVCTLcanbeusedtoshutdownOracleinstances.C)SQL*Pluscanbeusedtocreatedatabases.D)SQL*P

oracle
ocp
cuug
052
原创 2019-08-14 13:21:51 262 阅读

OCP-052考试题库汇总（30）-CUUG内部解答版

WhichtwoaretrueabouttheInventorydirectory?A)ItissharedbyallOraclesoftwareinstallationsonasingleserver.B)ItisrequiredonlyforOracleGridInfrastructureandOracleDatabasesoftwareInstallations.C)Itcanbecreat

oracle
ocp
cuug
052
原创 2019-08-13 14:21:36 286 阅读

OCP-052考试题库汇总（29）-CUUG内部解答版

Whendoesanincrementalcheckpointoccur?A)whenanonlineredologswitchoccurs.B)whenDBWnwritesdirtybuffersaspartofitsnormalprocessing.C)whentheALTERSYSTEMCHECKPOINTstatementisexecuted.D)whenausertablespaceis

ocp
oracle
cuug
052
原创 2019-08-13 13:46:02 256 阅读

OCP-052考试题库汇总（28）-CUUG内部解答版

ArchivelogmodeisenabledforyourdatabaseandDB_CREATE_FILE_DESTissetto‘/u01/oracle/db01’.Theparameters,DB_CREATE_ONLINE_LOG_DEST_nandDB_RECOVERY_FILE_DEST,andnotspecified.Whichfourarestoredinthelocations

oracle
ocp
cuug
052
原创 2019-08-12 15:27:34 286 阅读

OCP-052考试题库汇总（27）-CUUG内部解答版

WhichtwoofthesemustbeavailableREAD/WRITEtokeepadatabaseopen?A)allcopiesofthecontrolfile.B)thepasswordfile.C)allmembersofthecurrentredologgroup.D)spfile.E)TEMPtablespaceF)SYSAUXtablespaceAnswer:AC

oracle
ocp
cuug
052
原创 2019-08-12 13:56:42 382 阅读
  • 1
  • 2
  • 3
  • 4

Copyright © 2005-2023 51CTO.COM 版权所有 京ICP证060544号

关于我们
官方博客 全部文章 热门标签 班级博客
了解我们 在线客服 网站地图 意见反馈
友情链接
开源基础软件社区 51CTO学堂
51CTO 汽车开发者社区