單項選擇題

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.

單項選擇題

In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information.
What action would you take to achieve this task（）

A.Apply fine-grained auditing.
B.Implement value-based auditing.
C.Impose standard database auditing to auditobject privileges.
D.Impose standard databaseauditing to audit SQL statements.

你可能感興趣的試題

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（）