Oracle
1Z0-083 · Question #248
1Z0-083 Question #248: Real Exam Question with Answer & Explanation
The correct answer is A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR C. Data is never redacted for the EMP_V.SAL column.. DBMS_REDACT.FULL completely redacts the column data. DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported. The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables
Question
You execute the following piece of code with appropriate privileges: User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?
Options
- AData is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR
- BData is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
- CData is never redacted for the EMP_V.SAL column.
- DData is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
- EData is redacted for the EMP_V.SAL column only if the SCOTT session does not have the
Explanation
- DBMS_REDACT.FULL completely redacts the column data. * DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported. * The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an * If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.
Community Discussion
No community discussion yet for this question.