nerdexam
Oracle

1Z0-146 · Question #38

You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for an attribute…

The correct answer is B. The attribute can be set only in the package associated with the context. See the full explanation below for the reasoning.

Question

You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for an attribute within the context:

SQL> EXECUTE DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); BEGIN DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); END; * ERROR at line 1:

ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line 94 ORA-06512: at line 1 What is the reason for this error?

Options

  • AThe context was created with a package name in the USING clause.
  • BThe attribute can be set only in the package associated with the context.
  • CThe package associated with the context did not exist at the time of creation of the context.
  • DThe value for an attribute of a user-defined context can be set only by the ALTER SESSION command.

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    84% (32)
  • C
    3% (1)
  • D
    11% (4)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-146 Practice