You execute the following commands to audit database activities: Which statement is true
about the audit record that generated when auditing after instance restarts?
A.
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.
B.
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.
C.
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.
D.
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.
E.
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.
Explanation:
D
D is incorrect.
It is not for every successful execution because the “BY SESSION” option is included.
B is correct.
Sorry E, is the correct one.
Execution plans in audit records?
plz explain why B is correct answer?
AUDIT_TRAIL=db, extended —> this mean populates the SQL bind and SQL text CLOB-type columns of the SYS.AUD$ table, when available.
So this will no where logged any execution plan .
ACE rules out.
D is saying that only SQL text .hence that is also rules out .
We left with B only .So B is correct answer.Hope I am right here .
Hope B is right
Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.
And, I learned valid 1Z0-060 dumps here: http://www.passleader.com/1z0-060.html (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
P.S. Free 1Z0-060 PDF dumps from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs
I think execution plan is not audited
——————
db
Directs audit records to the database audit trail (the SYS.AUD$ table), except for records that are always written to the operating system audit trail. Use this setting for a general database for manageability.
If the database was started in read-only mode with AUDIT_TRAIL set to db, then Oracle Database internally sets AUDIT_TRAIL to os. Check the alert log for details.
db, extended
Performs all actions of AUDIT_TRAIL=db, and also populates the SQL bind and SQL text CLOB-type columns of the SYS.AUD$ table, when available. These two columns are populated only when this parameter is specified.
If the database was started in read-only mode with AUDIT_TRAIL set to db, extended, then Oracle Database internally sets AUDIT_TRAIL to os. Check the alert log for details.
——————
https://docs.oracle.com/database/121/REFRN/GUID-BD86F593-B606-4367-9FB6-8DAB2E47E7FA.htm#REFRN10006
From 11g R2 release
BY SESSION
In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or operations of the same type executed on the same schema objects in the same session. Beginning with this release of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to write one audit record for each audited statement and operation. BY SESSION continues to populate different values to the audit trail compared with BY ACCESS. Oracle recommends that you include the BY ACCESS clause for all AUDIT statements, which results in a more detailed audit record. If you specify neither clause, then BY SESSION is the default.
WHENEVER [NOT] SUCCESSFUL
Specify WHENEVER SUCCESSFUL to audit only SQL statements and operations that succeed.
Specify WHENEVER NOT SUCCESSFUL to audit only statements and operations that fail or result in errors.
If you omit this clause, then Oracle Database performs the audit regardless of success or failure.
https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_4007.htm#SQLRF01107
If execution plan really not audited, then A, C and E is not true.
If Oracle write one audit record for each audited statement and operation, then B is not true.
I think D is correct for this question.