ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-144 All Questions

View all questions & answers for the 1z0-144 exam
Go to Exam

Exam 1z0-144 topic 1 question 48 discussion

Actual exam question from Oracle's 1z0-144
Question #: 48
Topic #: 1
[All 1z0-144 Questions]

Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS
PROCEDURE search_emp (empdet NUMBER);
PROCEDURE search_emp (empdet DATE);
PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2
PROCEDURE search_emp (empdet NUMBER); RETURN DATE

END emp_pkg -
/
The package is compiled successfully
Why would it generate an error at run tune?

  • A. Because function cannot be overload.
  • B. Because function cannot differ only in return type.
  • C. Because all the functions and procedures in the package cannot have the same number of parameters with the same parameter name.
  • D. Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER) cannot have identical parameter names and data types.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Aditya at April 17, 2022, 11:27 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Aditya
3 years, 1 month ago
B is right
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel