51CTO首页
内容精选
博客
学堂
精培
企业培训
CTO训练营
开源基础软件社区
元宇宙大会
AISummit人工智能大会
移动端
公众号矩阵
博客
免费课程 课程排行 直播课 软考学堂
精品班 厂商认证 IT技术 2022年软考 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
原创 点赞0 阅读507 收藏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 阅读274 收藏0 评论0 2019-09-18

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读458 收藏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 阅读354 收藏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 阅读373 收藏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 阅读307 收藏0 评论0 2019-09-09

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

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

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

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

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

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

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

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

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

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读295 收藏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 阅读338 收藏0 评论0 2019-08-29

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读299 收藏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 阅读345 收藏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 阅读356 收藏0 评论0 2019-08-23

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读363 收藏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 阅读240 收藏0 评论0 2019-08-22

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

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

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

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读244 收藏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 阅读258 收藏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 阅读306 收藏0 评论0 2019-08-20

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

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

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

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

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

oracle
ocp
cuug
052
原创 点赞0 阅读334 收藏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 阅读385 收藏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 阅读274 收藏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 阅读237 收藏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 阅读238 收藏0 评论0 2019-08-14

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

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

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

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

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

ocp
oracle
cuug
052
原创 点赞0 阅读218 收藏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 阅读272 收藏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 阅读307 收藏0 评论0 2019-08-12
  • 1
  • 2
  • 3
  • 4

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

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