51CTO首页
AI.x社区
博客
学堂
精品班
软考社区
免费课
企业培训
鸿蒙开发者社区
WOT技术大会
IT证书
公众号矩阵
移动端
短视频 免费课程 课程排行 直播课 软考学堂
全部课程 厂商认证 IT技术 24年11月软考 PMP项目管理 免费题库
在线学习
文章 资源 问答 课堂 专栏 直播
51CTO
鸿蒙开发者社区
51CTO技术栈
51CTO官微
51CTO学堂
51CTO博客
CTO训练营
鸿蒙开发者社区订阅号
51CTO软考
51CTO学堂APP
51CTO学堂企业版APP
鸿蒙开发者社区视频号
51CTO软考题库
# 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 538 阅读

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 316 阅读

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

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

oracle
ocp
cuug
052
原创 2019-09-11 10:47:52 530 阅读 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 699 阅读

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 405 阅读

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 360 阅读

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

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

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

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

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

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

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

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

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

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

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

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

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 411 阅读

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

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

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

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 391 阅读

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 399 阅读

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

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

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

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 288 阅读

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

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

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

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

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

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

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 308 阅读

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 373 阅读

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

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

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

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

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

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

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 461 阅读

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 310 阅读

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 286 阅读

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 282 阅读

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

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

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

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

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

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

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 297 阅读

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 415 阅读
  • 1
  • 2
  • 3
  • 4

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

关于我们
官方博客 全部文章 热门标签 班级博客
了解我们 网站地图 意见反馈
友情链接
鸿蒙开发者社区 51CTO学堂
51CTO 软考资讯