You execute the following PL/SQL:
Which two statements are true?
A.
Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT
statements only when a row with PRICE > 10000 is accessed.
B.
FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with
PRICE > 10000 is accessed.
C.
FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
D.
FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the
FGA audit trial.
Explanation:
DBMS_FGA.ADD_POLICY(
object_schema => hr`,
object_name => emp`,
policy_name => chk_hr_emp`,
audit_condition => dept = SALES ,
audit_column => salary`
statement_types => insert,update,delete,select`);
Default value for statement_types is SELECT
Setting audit_trail to DBMS_FGA.DB sends the audit trail to the SYS.FGA_LOG$ table in the database and
omits SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.DB+EXTENDED sends the audit trail to the SYS.FGA_LOG$ table in the
database and includes SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.XML writes the audit trail in XML files sent to the operating system and omits
SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.XML+EXTENDED writes the audit trail in XML files sent to the operat- ing
system and includes SQL Text and SQL Bind.
Default value fo audit_trail parameter in DBMS_FGA.ADD_POLICY is DB+EXTENDED
A, D are correct.
A) The default value for (statement_types) parameter of dbms_fga.add_policy procedure is (SELECT)
DBMS_FGA.ADD_POLICY(
object_schema IN VARCHAR2 DEFAULT NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
audit_condition IN VARCHAR2 DEFAULT NULL,
audit_column IN VARCHAR2 DEFAULT NULL,
handler_schema IN VARCHAR2 DEFAULT NULL,
handler_module IN VARCHAR2 DEFAULT NULL,
enable IN BOOLEAN DEFAULT TRUE,
statement_types IN VARCHAR2 DEFAULT SELECT,
audit_trail IN BINARY_INTEGER DEFAULT NULL,
audit_column_opts IN BINARY_INTEGER DEFAULT ANY_COLUMNS,
policy_owner IN VARCHAR2 DEFAULT NULL);