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.
AD
Not B: Each audit policy is applied to the query individually. However, at most one audit record may be generated for each policy, no matter how many rows being returned satisfy that policy’s audit_condition. In other words, whenever any number of rows being returned satisfy an audit condition defined on the table, a single audit record will be generated for each such policy.
AD
I think BD as the audit will also write a record with an update or delete statement.
not only a select.
Default value for statement_types is SELECT.
So A and D are correct options