OCP考试052必威体育精装版考试题库原题-9-20180803.pdf

052 题库解析 OCP 考试 052 必威体育精装版考试题库原题 -9 十三 .Audit 32.YouwanttoauditupdatestatementsthatrefertoUSER1.DEPT.DNAME. Which typeofauditingmust youuse? A) standardauditing B) mandatoryauditing C) value-basedauditing D)?ne-grainedauditing Answer ：D 33.Whichthreearetrueaboutauditing? A)Auditingis activeonlywhenthedatabaseis OPEN. B)Auditrecords arealwaysstored inthedatabase. C)Auditof theuseofsystemprivilegescanbeenabledfor individual databaseusers. D) DDLstatements canbe auditedwhentheyfailtoexecute. E)AllOracleauditingoperationsoccurbydefault. F) DMLstatements canbeauditedwhentheyexecutesuccessfully. Answer ：CDF 34.Whichfour aretrue aboutauditing? A) DMLstatementscanbeauditedwhentheyfailtoexecute B) Select statementscanbeauditedwhentheyexecutesuccessfully. C)AllOracle auditingoperationsoccurby default. D) NoOracleauditingoperationsoccurby default. E) DDLstatements canbe auditedwhentheyfailtoexecute. F) Someauditingis activebeforethedatabaseis open. G)Auditrecordsareneverstored inthe database. H)Auditrecordsarealwaysstored inthedatabase. Answer ：ABEF 34. Examinethissessionoutput: SQLconnectscott/tigerConnected. SQLselectname,value 2fromv$parameter 3wherename =audit_trail; NAMEVALUE audit_trailDB SQLauditall onemp; Auditsucceeded. Whichtwowillgenerateanauditrecord ? A) everyUPDATEstatement executedbySCOTTthatupdatesSCOTT.EMP. B) everyDDLstatementexecutedby SCOTTthataffectsSCOTT.EMP. C) anyDMLstatement executedbySYS onSCOTT.EMP. D) onlythe ?rstSELECTstatement executedbySCOTTina sessionon SCOTT.EMP E) everyUPDATEstatement executedbySCOTTthatupdatesHR.EMP Answer:AB 十 .DBlink 36.yousuccessfullyexecutedthesecommands: connectscott/tiger@prod1; CREAETDATABASE LINKdb_prod2 CONNECTTOscott IDENTIFIED BYtiger USING PROD2; Whichtype ofdatabase linkiscreated? A) private currentuserdatabaselink B) publicconnecteduserdatabaselink C)publiccur