READ Free Dumps For Oracle- 1z0-146
Question ID 20616 | Execute the following PL/SQL command in the user session: All PL/SQL blocks that are executed subsequently in the session are traced |
Option A | All PL/SQL blocks that are executed subsequently in the session are traced |
Option B | It enables all PL/SQL blocks that are compiled subsequently in the session for tracing |
Option C | Only anonymous PL/SQL blocks that are executed subsequently in the session are traced |
Option D | It enables only named PL/SQL block that are executed subsequently in the session for tracing |
Correct Answer | B |
Question ID 20617 | You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the RODERS table in the The security policy remains in effect till the end of the current session |
Option A | The security policy remains in effect till the end of the current session |
Option B | The subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error |
Option C | The subsequent queries on the ORDERS table within the current session are not controlled by the security policy |
Option D | The subsequent queries on the ORDERS table produce an ORA-28112; failed to execute policy function error |
Correct Answer | C |