Exit GSNA GIAC Systems and Network Auditor (GSNA)
Question 4 of 5
0% complete
Q4 Multiple choice

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?

Select all that apply.

  • 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;

Previous Next