【OCP｜052】2018最新考试题库原题-9-cuug

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

1、cuug-052题库解析最新15道题www.cuug.com题库新特点：l最新052题库，按知识点分类，方便大家学习www.cuug.com十三.Audit32.YouwanttoauditupdatestatementsthatrefertoUSER1.DEPT.DNAME. Whichtypeofauditingmustyouuse?A)standardauditingB)mandatoryauditingC)value-basedauditingD)fine-grainedauditingAnswer：Dwww.cuug.c

2、om33.Whichthreearetrueaboutauditing?A)AuditingisactiveonlywhenthedatabaseisOPEN. B)Auditrecordsarealwaysstoredinthedatabase. C)Auditoftheuseofsystemprivilegescanbeenabledforindividual databaseusers.D)DDLstatementscanbeauditedwhentheyfailtoexecute. E)AllOracleauditing

3、operationsoccurbydefault.F)DMLstatementscanbeauditedwhentheyexecutesuccessfully.Answer：CDFwww.cuug.com34.Whichfouraretrueaboutauditing?A)DMLstatementscanbeauditedwhentheyfailtoexecute B)Selectstatementscanbeauditedwhentheyexecutesuccessfully. C)AllOracleauditingopera

4、tionsoccurbydefault.D)NoOracleauditingoperationsoccurbydefault.E)DDLstatementscanbeauditedwhentheyfailtoexecute. F)Someauditingisactivebeforethedatabaseisopen. G)Auditrecordsareneverstoredinthedatabase.H)Auditrecordsarealwaysstoredinthedatabase.Answer：ABEFwww.cuug.co

5、m34.Examinethissessionoutput:SQL>connectscott/tigerConnected.SQL>selectname,value 2fromv$parameter3wherename='audit_trail';NAMEVALUE---------------------------------------- audit_trailDBSQL>auditallonemp; Auditsucceeded.www.cuug.comWhichtwowillgenerateanauditrecord?A

6、)everyUPDATEstatementexecutedbySCOTTthatupdatesSCOTT.EMP. B)everyDDLstatementexecutedbySCOTTthataffectsSCOTT.EMP. C)anyDMLstatementexecutedbySYSonSCOTT.EMP. D)onlythefirstSELECTstatementexecutedbySCOTTinasessionon SCOTT.EMPE)everyUPDATEstatementexecutedbySCOTTthatupda

7、tesHR.EMPAnswer:ABwww.cuug.com十.DBlink36.yousuccessfullyexecutedthesecommands:connectscott/tiger@prod1;CREAETDATABASELINKdb_prod2CONNECTTOscottIDENTIFIEDBYtigerUSING'PROD2';Whichtypeofdatabaselinkiscreated?A)privatecurrentuserdatabaselink B)publicconnecteduserdatabas

8、elink C)publiccurrentuserdatabaselink D)privatefixeduserdatabaselink E)publicfixeduserdatabaselinkAnswer：Dwww.cuug.comwww.cuug.com十五.