Oracle
1Z0-074 · Question #37
You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code: The SCOTT user has the SELECT privilege on HR.EMP. Which statement is true about queries by non-DBA users…
The correct answer is A. All their queries display blanks for LAST_NAME and the true contents of the SALARY column. Explanation/Reference:
New Features for Security
Question
You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:
The SCOTT user has the SELECT privilege on HR.EMP. Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?
Exhibit
Options
- AAll their queries display blanks for LAST_NAME and the true contents of the SALARY column.
- BOnly SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.
- CAll their queries display blanks for LAST_NAME and zeroes for SALARY.
- DOnly SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.
- EOnly SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.
How the community answered
(37 responses)- A84% (31)
- C8% (3)
- D3% (1)
- E5% (2)
Explanation
Explanation/Reference:
Topics
#data redaction#column masking#VPD policy#SELECT privilege
Community Discussion
No community discussion yet for this question.