51CTO首页
内容精选
博客
学堂
精培
企业培训
CTO训练营
开源基础软件社区
元宇宙大会
AISummit人工智能大会
移动端
公众号矩阵
博客
免费课程 课程排行 直播课 软考学堂
精品班 厂商认证 IT技术 2022年软考 PMP项目管理
在线学习 企业服务
CTO训练营 技术经理研习营 LeaTech峰会
文章 资源 问答 开源课堂 专栏 直播
# 2018 ocp 11g

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读513 收藏0 评论0 2019-09-18

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读278 收藏0 评论0 2019-09-18

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读464 收藏0 评论1 2019-09-11

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读377 收藏0 评论0 2019-09-10

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
原创 点赞0 阅读375 收藏0 评论0 2019-09-10

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读313 收藏0 评论0 2019-09-09

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读327 收藏0 评论0 2019-09-09

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读293 收藏0 评论0 2019-09-04

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读239 收藏0 评论0 2019-09-04

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读302 收藏0 评论0 2019-08-30

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读346 收藏0 评论0 2019-08-29

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读312 收藏0 评论0 2019-08-28

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读351 收藏0 评论0 2019-08-28

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读359 收藏0 评论0 2019-08-23

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读370 收藏0 评论0 2019-08-22

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读248 收藏0 评论0 2019-08-22

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读248 收藏0 评论0 2019-08-21

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读253 收藏0 评论0 2019-08-21

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读263 收藏0 评论0 2019-08-20

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
原创 点赞0 阅读317 收藏0 评论0 2019-08-20

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读411 收藏0 评论0 2019-08-19

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读336 收藏0 评论0 2019-08-19

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
原创 点赞0 阅读389 收藏0 评论0 2019-08-15

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读277 收藏0 评论0 2019-08-15

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

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

ocp
cuug
oracle
052
原创 点赞0 阅读239 收藏0 评论0 2019-08-14

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读244 收藏0 评论0 2019-08-14

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读254 收藏0 评论0 2019-08-13

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

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

ocp
oracle
cuug
052
原创 点赞0 阅读229 收藏0 评论0 2019-08-13

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
原创 点赞0 阅读278 收藏0 评论0 2019-08-12

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读313 收藏0 评论0 2019-08-12
  • 1
  • 2
  • 3

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

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