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 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
D
Setting audit_trail to DBMS_FGA.DB + DBMS_FGA.EXTENDED sends the audit trail to the SYS.FGA_LOG$ table in the database and includes SQL Text and SQL Bind.
https://docs.oracle.com/database/121/ARPLS/d_fga.htm#ARPLS225
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-060 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Nilendu
3 years agoAnnieHuang
3 years, 10 months ago