1Z0-149: Oracle Database Program with PL/SQLDemo

By Oracle · Question Mode

QuestionQ22

PL/SQL Language Fundamentals

Examine the following statements:

Question Image

Which statement is true?

  • A It will result in a compilation error for protected_proc because calling_proc does not exist.
  • B It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
  • C It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
  • D With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.
Explanation

An entity named in an ACCESSIBLE BY accessor list is not required to exist when the protected PL/SQL unit is compiled. A schema qualifier is optional for an accessor in the same schema. At invocation, ACCESSIBLE BY adds an access check that permits only the listed accessor to make a direct call; ordinary privileges do not allow other programs to bypass that restriction.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!