Oracle
1Z0-060 · Question #65
1Z0-060 Question #65: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #65. The question stem and answer options stay visible for context.
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?
Exhibit
Options
- AData is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
- 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 MGR role set.
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.