GIAC
GSNA · Question #352
GSNA Question #352: Real Exam Question with Answer & Explanation
Sign in or unlock GSNA to reveal the answer and full explanation for question #352. The question stem and answer options stay visible for context.
Question
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?
Options
- AALTER SYSTEM SET AUDIT_TRAIL = DB, XML SCOPE=SPFILE;
- BALTER SYSTEM SET AUDIT_TRAIL = 'DB, EXTENDED' SCOPE=SPFILE;
- CALTER SYSTEM SET AUDIT_TRAIL = 'DB','EXTENDED' SCOPE=SPFILE;
- DALTER SYSTEM SET AUDIT_TRAIL = DB, EXTENDED SCOPE=SPFILE;
- EALTER SYSTEM SET AUDIT_FILE_DEST = 'DB, EXTENDED' SCOPE=SPFILE;
- FALTER SYSTEM SET AUDIT_TRAIL = DB, EXTENDED SCOPE=BOTH;
Unlock GSNA to see the answer
You've previewed enough free GSNA questions. Unlock GSNA 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.