1z0-074 Exam Dumps | You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code: (Exhibit)

<< Prev Question Next 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-DBAusers with the SELECTprivilege on HR.EMP?

A. Only SCOTT'Squeries display the true contents of the SALARYand LAST_NAMEcolumns.

B. All their queries display blanks for LAST_NAMEand the true contents of the SALARYcolumn.

C. All their queries display blanks for LAST_NAMEand zeroes for SALARY.

D. Only SCOTT'Squeries display zero for SALARYand the true contents of the LAST_NAMEcolumn.

E. Only SCOTT'Squeries display the true contents of the SALARYcolumn and blanks for LAST_NAME.

Download PDF File