You execute the following PL/SQL: Which two statements are true? (Choose two.)
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.
STATEMENT_TYPE-> SELECT (default) since not mentioned, hence A.
D-SQL text and bind variables get captured in audit logs (audit_policy default is DB+EXTENDED which sends the audit trail to the SYS.FGA_LOG$ table in the database and includes SQL Text and SQL Bind)
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
yosiw96816
Highly Voted 4 years, 3 months agoyosiw96816
4 years, 3 months agoRay520
Most Recent 2 years, 9 months agojackymak
3 years, 1 month agokatetel
3 years, 8 months agocharan94
4 years agoNorthKorean
5 years, 1 month agojackymak
3 years, 2 months ago