You execute the following PL/SQL: Which two statements are true?

The correct answer is A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row. DBMS_FGA.add_policy The DBMS_FGA package provides fine-grained security functions. ADD_POLICY Procedure This procedure creates an audit policy using the supplied predicate as the audit condition. Not C: object_schema The schema of the object to be audited. (If NULL, the current l

Implementing Oracle Database Auditing

Question

You execute the following PL/SQL:

Which two statements are true?

Exhibit

Options

AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for
BFGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row
CFGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
DFGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is

How the community answered

(52 responses)

A
81% (42)
C
13% (7)
D
6% (3)

Explanation

DBMS_FGA.add_policy * The DBMS_FGA package provides fine-grained security functions. * ADD_POLICY Procedure This procedure creates an audit policy using the supplied predicate as the audit condition. Not C: object_schema The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.)

Topics

#Fine-Grained Auditing#FGA#auditing

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice