ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam
Go to Exam

Exam 1z0-148 topic 1 question 23 discussion

Actual exam question from Oracle's 1z0-148
Question #: 23
Topic #: 1
[All 1z0-148 Questions]

Which two statements are true with respect to fine-grained access control?

  • A. It is implemented by end users.
  • B. It can be used to implement column masking.
  • C. It implements security rules through functions and associates these security rules with tables, views or synonyms.
  • D. Separate policies are required for queries versus INSERT/UPDATE/DELETE statements.
  • E. The DBMS_FGA package is used to set up fine-grained access control.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/security.htm
by orakell at Dec. 8, 2019, 12:35 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
CosminCof
Highly Voted 4 years, 2 months ago
BC is correct
upvoted 6 times
...
Rakeshpro
Most Recent 2 years, 4 months ago
DBMS_RLS.ADD_POLICY can implement fine-grained access control
upvoted 1 times
Rakeshpro
2 years, 4 months ago
https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_RLS.html#GUID-DF820496-D34E-4ACE-93C1-F9523D8893C8
upvoted 1 times
...
...
chrishillinger
2 years, 5 months ago
Selected Answer: BC
BC is correct
upvoted 1 times
...
jcamt
4 years, 3 months ago
C and D because the mask is in FGA and not Fine Grained Access Control https://docs.oracle.com/cd/B19306_01/network.102/b14266/apdvpoli.htm#i1008295
upvoted 1 times
...
kahabe59
4 years, 11 months ago
C and E are correct. You can't mask columns but lines by FGA
upvoted 1 times
kahabe59
4 years, 10 months ago
I have to admit i was wrong. Column masking is possible so correct answers are B and C. DBMS_FGA is used for Fine Grained Auditing.
upvoted 4 times
szefco
4 years, 8 months ago
Confirm, B and C are correct answers
upvoted 1 times
...
...
...
orakell
5 years, 2 months ago
BC, not CD. The linked reference says you CAN use separate policies, not that you're REQUIRED to use separate policies.
upvoted 4 times
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago