Which two statements are true?

You execute the following PL/SQL:

Which two statements are true?

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
* 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.
Incorrect:
Not C: object_schema

The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.)



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Mohamed

Mohamed

A and D are correct.

myself

myself

D is not correct as audit is enabled on price col only if the condition price > 10000 satisfies

Charmain

Charmain

Downlaod new Madden 17 Coin Glitch and Generator game!
Best Madden NFL 17 Coin Glitch and Generator for unlimied Cash and Coins!

DOWNLOADLINK : Madden NFL 17 Coin Glich and Generator

Thekar

Thekar

Correct picture on question 91.

Thekar

Thekar

Correct picture on question 91. Click Show Answer.