Oracle
1Z0-146 · Question #69
1Z0-146 Question #69: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Question
You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schem a. The user sessions are able to access only the desired rows. The database administrator (DBA) uses the following command: SQL> EXECUTE DBMS_RLS.ENABLE_POLICY('OE','ORDERS','OE_ORDERS_ACCESS_POLICY',FALSE); Which statement is true about user sessions that are connected currently?
Options
- AThe security policy remains in effect till the end of the current session.
- BThe subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error.
- CThe subsequent queries on the ORDERS table within the current session are not controlled by the
- DThe subsequent queries on the ORDERS table produce an ORA-28112: failed to execute policy
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 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.