OCP考试052最新考试题库原题-9-20180803

《OCP考试052最新考试题库原题-9-20180803》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、052题库解析最新15道题052-题库解析-9-20180803题库新特点：l最新052题库，按知识点分类，方便大家学习每周五晚8点-直播地址：ke.qq.com/course/326223ocp考试讨论群：836361015验证：ocpCUUG整理，官网：www.cuug.com十三.Audit32.YouwanttoauditupdatestatementsthatrefertoUSER1.DEPT.DNAME. Whichtypeofauditingmustyouuse?A)standardauditingB)manda

2、toryauditingC)value-basedauditingD)fine-grainedauditingAnswer：D33.Whichthreearetrueaboutauditing?A)AuditingisactiveonlywhenthedatabaseisOPEN. B)Auditrecordsarealwaysstoredinthedatabase. C)Auditoftheuseofsystemprivilegescanbeenabledforindividual databaseusers.D)DDLsta

3、tementscanbeauditedwhentheyfailtoexecute. E)AllOracleauditingoperationsoccurbydefault.F)DMLstatementscanbeauditedwhentheyexecutesuccessfully.Answer：CDF34.Whichfouraretrueaboutauditing?A)DMLstatementscanbeauditedwhentheyfailtoexecute B)Selectstatementscanbeauditedwhe

4、ntheyexecutesuccessfully. C)AllOracleauditingoperationsoccurbydefault.D)NoOracleauditingoperationsoccurbydefault.E)DDLstatementscanbeauditedwhentheyfailtoexecute. F)Someauditingisactivebeforethedatabaseisopen. G)Auditrecordsareneverstoredinthedatabase.H)Auditrecords

5、arealwaysstoredinthedatabase.Answer：ABEF34.Examinethissessionoutput:SQL>connectscott/tigerConnected.SQL>selectname,value 2fromv$parameter3wherename='audit_trail';NAMEVALUE---------------------------------------- audit_trailDBSQL>auditallonemp; Auditsucceeded.Whichtw

6、owillgenerateanauditrecord?A)everyUPDATEstatementexecutedbySCOTTthatupdatesSCOTT.EMP. B)everyDDLstatementexecutedbySCOTTthataffectsSCOTT.EMP. C)anyDMLstatementexecutedbySYSonSCOTT.EMP. D)onlythefirstSELECTstatementexecutedbySCOTTinasessionon SCOTT.EMPE)everyUPDATEsta

7、tementexecutedbySCOTTthatupdatesHR.EMPAnswer:AB十.DBlink36.yousuccessfullyexecutedthesecommands:connectscott/tiger@prod1;CREAETDATABASELINKdb_prod2CONNECTTOscottIDENTIFIEDBYtigerUSING'PROD2';Whichtypeofdatabaselinkiscreated?A)privatecurrentuserdatabaselink B)publicco

8、nnecteduserdatabaselink C)publiccurrentuserdatabaselink D)privatefixeduserdatabaselink E)publicfixeduserdatabaselinkAnswer：D十五.ExternalTable