网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

You execute the following commands to audit database activities:SQL >ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL >AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;Which statement is true about the audit record that generated when auditing after instance restarts?（）

A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

参考答案

更多 “ You execute the following commands to audit database activities:SQL >ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL >AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;Which statement is true about the audit record that generated when auditing after instance restarts?（）A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used. ” 相关考题
考题 You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
查看答案
考题 importjava.util.*；classKeyMaster{publicinti；publicKeyMaster（inti）{this.i=i；}publicbooleanequals（Objecto）{returni==（（KeyMaster）o）.i；}publicinthashCode（）{returni；}}publicclassMapIt{publicstaticvoidmain（String[]args）{Setset=newHashSet（）；KeyMasterk1=newKeyMaster（1）；KeyMasterk2=newKeyMaster（2）；set.add（k1）；set.add（k1）；set.add（k2）；set.add（k2）；System.out.print（set.size（）+：”）；k2.i=1；System.out.print（set.size（）+：”）；set.remove（k1）；System.out.print（set.size（）+：”）；set.remove（k2）；System.out.print（set.size（））；}}Whatistheresult？（）
查看答案
考题 Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? () A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTE
查看答案
考题 You enabled an audit policy by issuing the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? （）A. SYS, SYSTEMB. SCOTTC. Only for successful executionsD. Only for failed executionsE. Both successful and failed executions
查看答案
考题 You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?（）A. All users except SYSB. All users except SCOTTC. All users except sys and SCOTTD. All users except sys, system, and SCOTT
查看答案
考题 SQL语言中，CREATE、DROP、ALTER语句是实现 ______ 功能的。
查看答案
考题 要使“商品”表中所有商品的单价上浮10%，正确的SQL命令是（ ）。A. ALTER商品SET单价=单价*1．1 FOR ALLB. UPDATE商品SET单价=单价+单价*10%C. UPDATE商品SET单价=单价*1．1 FOR ALLD. UPDATE商品SET单价=单价*1．1
查看答案
考题 Oracle中如何设置audittrail审计，正确的说法是：（）A、在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”B、以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计C、Oracle不支持对audittrail的审计D、在设置audittrail审计前，要保证已经打开Oracle的审计机制
查看答案
考题 heDBAisabouttoenableauditingontheOracledatabaseinanattempttodiscoversomesuspiciousactivity.Audittrailinformationisstoredinwhichofthefollowingdatabaseobjectnames?() A.SYS.SOURCE$B.SYS.AUD$C.DBA_SOURCED.DBA_AUDIT_TRAIL
查看答案
考题 Oracle中启用审计后,查看审计信息的语句是下面哪一个?() A.select*fromSYS.AUDIT$B.select*fromsysloginsC.select*fromSYS.AUD$D.AUDIT SESSION
查看答案
热门标签
最新试卷