Oracle
1Z0-146 · Question #101
1Z0-146 Question #101: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #101. The question stem and answer options stay visible for context.
Question
You created the SALES_ORDERS_CTX context to use the OE.SALES_ORDERS_PKG package. View Exhibit1 and examine the package that is used with the context. View Exhibit2 to examine the policy defined and the logon trigger. A user receives the following error when he or she executes a query: ERROR at line 2: ORA-28112: failed to execute policy function What could be the reason for the error?
Options
- AThe user has insufficient privileges on the DBMS_SESSION package.
- BThe subprograms inside the package have not been created with the invoker's right.
- CThe THE_PREDICATE function has an insufficient number of parameters in the package.
- DThe policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter.
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.