Oracle
1Z0-052 · Question #62
To make audit information more productive, the DBA executes the following command before starting an audit operations: SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Which statement is tru
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #62. The question stem and answer options stay visible for context.
Implementing Oracle Database Auditing
Question
To make audit information more productive, the DBA executes the following command before starting an audit operations:
SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Which statement is true regarding the audit record generated when auditing starts after restarting the database?
Options
- AIt contains only the plan for the SQL statement executed by the user
- BIt contains the SQL text executed by the user and the bind variables used with it
- CIt contains the plan and statistics associated with the SQL statement executed by the user
- DIt contains the plan for the SQL statement executed by the user and the bind variables used with it
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#AUDIT_TRAIL#DB EXTENDED#bind variables#audit records