ExamQuestions.com

Register
Login
Upgrade to Oracle Database 12c Exam Questions

Oracle

Upgrade to Oracle Database 12c

80 / 125

Question 80:

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

Answer options:

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.