Exam 1z0-148 topic 1 question 59 discussion

Actual exam question from Oracle's 1z0-148

Question #: 59
Topic #: 1

[All 1z0-148 Questions]

Which two can be used to find details of parameters for overloaded PL/SQL routines?

A. ALL-DEPENDENCIES
B. ALL_PROCEDURES
C. ALL_DESCRIBE
D. ALL_SOURCE
E. ALL_ARGUMENTS

Show Suggested Answer

Suggested Answer: DE 🗳️
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1014.htm#REFRN20015

by szefco at June 13, 2020, 9:46 p.m.

Comments

Submit Cancel

chrishillinger

2 years, 9 months ago

Selected Answer: DE

Since the question asks specifically for information on parameters of procedures, B can't be right

upvoted 1 times

...

sudhirdavim

4 years, 5 months ago

all_procedures don't have any details about arguments. So answer is DE.

upvoted 1 times

You are right, in all_procedures you have just an column called "overload" wich says if the procedure/function is overloade, but here I think it's about of syllabus of the question. They ask which 2 table can be used to know details about arguments (In my opinion they talked about using in the same time 2 tables, not separately). So you can know details of arguments using a join: SELECT a.* FROM all_arguments a, all_procedures p WHERE p.overload IS NOT NULL AND a.OBJECT_NAME = p.PROCEDURE_NAME ORDER BY p.PROCEDURE_NAME DESC, p.overload DESC;

upvoted 1 times

...