YOU ISSUE THIS STATEMENT

17. You issue this statement:

audit select on hr.emp by access;

but when you issue the command:

select * from hr.emp where employee_id=0;

no audit record is generated. Why might this be? (Choose the best answer.)

A. You are connected as SYS, and the parameter AUDIT_SYS_OPERATIONS is

set to FALSE.

B. The AUDIT_TRAIL parameter is set to NONE.

C. The statement did not access any rows; there is no row with EMPLOYEE_

ID equal to zero.

D. The instance must be restarted before any change to auditing comes into

effect.

Self Test Answers