You installed Oracle Database 11g at fresh. Which statements are true regarding the default
audit settings in this database? (Choose all that apply.)
A.
The audit trail is stored in an operating system file.
B.
Auditing is disabled for all privileges.
C.
The audit trail is stored in the database.
D.
Auditing is enabled for all privileges.
E.
Auditing is enabled for certain privileges related to database security.
https://docs.oracle.com/cd/B19306_01/network.102/b14266/cfgaudit.htm#i1007942
A is half correct:
All audit records for SYS are written to the operating system file that contains the audit trail, and not to SYS.AUD$ (also viewable as DBA_AUDIT_TRAIL).
B is incorrect:
The default value, FALSE, disables SYS auditing.
C is correct:
The data dictionary of every database has a table named SYS.AUD$, commonly referred to as the database audit trail, that is designed to store entries auditing database statements, privileges, or schema objects. https://docs.oracle.com/cd/A97630_01/server.920/a96521/audit.htm
D is incorrect
E is correct