Oracle
1Z0-074 · Question #37
1Z0-074 Question #37: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 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.