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

Question

Exhibit

Options

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

• A
  74% (51)
• B
  7% (5)
• C
  19% (13)

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 operating system and includes SQL Text and SQL Bind. Default value fo audit_trail parameter in DBMS_FGA.ADD_POLICY is DB+EXTENDED So, based on these the correct answer should be A and D. B is not correct because this FGA policy is not true for insert, update and delete statements.

No community discussion yet for this question.