READ Free Dumps For Oracle- 1z0-060
| Question ID 2177 |
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? |
| Option A | A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set. |
| Option B | B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set. |
| Option C | C. Data is never redacted for the EMP V.SAL column. |
| Option D | D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set. |
| Option E | E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. |
| Correct Answer | A,C |
| Question ID 2178 | Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command: |
| Option A | A. They are able to perform only queries. |
| Option B | B. They are not affected and continue to function normally. |
| Option C | C. They are terminated and the active transactions are rolled back. |
| Option D | D. They are not allowed to perform any operations until the listener LISTENER is started. |
| Correct Answer | B |