You want to record auditing information in the SYS.AUD$ table, and also want to record SQL bind variables as well as the SQL text in the audit trail.
Which of the following statements will accomplish this task?
A. ALTER SYSTEM SET AUDIT_TRAIL = DB, XML SCOPE=SPFILE;
B. ALTER SYSTEM SET AUDIT_TRAIL = 'DB, EXTENDED' SCOPE=SPFILE;
C. ALTER SYSTEM SET AUDIT_TRAIL = 'DB','EXTENDED'SCOPE=SPFILE;
D. ALTER SYSTEM SET AUDIT_TRAIL = DB, EXTENDED SCOPE=SPFILE;
E. ALTER SYSTEM SET AUDIT_FILE_DEST = 'DB, EXTENDED' SCOPE=SPFILE;
F. ALTER SYSTEM SET AUDIT_TRAIL = DB, EXTENDED SCOPE=BOTH;
You want to record auditing information in the SYS.AUD$ table, and also want to record SQL bind variables as well as the
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You want to record auditing information in the SYS.AUD$ table, and also want to record SQL bind variables as well as the
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!