多項選擇題

Which two statements are true about standard database auditing（）

A.DDL statements can be audited.
B.Statements that refer to stand-alone procedure can be audited.
C.Operations by the users logged on as SYSDBA cannot be audited.
D.Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

你可能感興趣的試題

單項選擇題

To make audit information more productive， the DBA executes the following command before startingan audit operation：
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；
Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）

A.It contains only the plan for the SQL statement executed by the user.
B.It contains the SQL text executed by the user and the bind variables used with it.
C.It contains the plan and statistics associated with the SQL statement executed by the user.
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it.

單項選擇題

You execute the following command toauditdatabase activities：
SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；
What is the effect of this command（）

A.Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
B.Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Which two statements are true about standard database auditing（）

你可能感興趣的試題

You execute the following command toauditdatabase activities： SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

You execute the following command toauditdatabase activities：
SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；
What is the effect of this command（）