Free 1Z0-148 Web TestEngine Demo

Q23 Single choice

You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schema. 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?

A
The security policy remains in effect till the end of the current session.
B
The subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error.
C
The subsequent queries on the ORDERS table within the current session are not controlled by the security policy.
D
The subsequent queries on the ORDERS table produce an ORA-28112: failed to execute policy function error.

1Z0-148 Web TestEngine demo