Examice

Exam 1z0-149 All QuestionsBrowse all questions from this exam

Question 17

Examine these statements:

Which is true?

It will result in a compilation error for protected_proc because calling_proc does not exist.

It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

Correct Answer: C

In Oracle, the ACCESSIBLE BY clause does not require that the referenced object be present at the compile time. This means the procedure 'protected_proc' will compile successfully even if 'calling_proc' does not exist, as objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

Discussion

jfc1Option: C

C is the correct answer

pmeyerOption: C

Correct Answer is "C" "Oracle An entity named in an accessor is not required to exist." https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/ACCESSIBLE-BY-clause.html#GUID-9720619C-9862-4123-96E7-3E85F240FF36

alinaabalaseiOption: C

C is correct

pmeyerOption: C

C is correct.

thranduylOption: C

C, TESTED!

[Removed]Option: C

Why is it show A as the correct answer when the correct answer is C?

Phoenix913Option: C

C is correct from 12.2