Exam 1z0-148 topic 1 question 57 discussion

Actual exam question from Oracle's 1z0-148

Question #: 57
Topic #: 1

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.

Examine this PL/SQL package AS -

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

A. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /
B. CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /
C. CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /
D. CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END; /
E. CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IS total NUMBER :=0; BEGIN RETUNRN total; END;

Show Suggested Answer

Suggested Answer: BC 🗳️

by Tinamoran at Nov. 8, 2019, 11:56 a.m.

Comments

Submit Cancel

Rakeshpro

2 years, 4 months ago

NUMBER & POSITIVEN

upvoted 1 times

...

CosminCof

4 years, 4 months ago

A, B and E (A and B are identicall)

upvoted 1 times

...

orakell

5 years, 2 months ago

C is most certainly not one of the answers. A PLS_INTEGER will be implicitly converted to a NUMBER and a BINARY_FLOAT

upvoted 4 times

...

Tinamoran

5 years, 3 months ago

What is the difference between a and b?

upvoted 3 times

orakell

5 years, 2 months ago

I think one of those should say NATURAL or NATURALN. And the answer is incorrect on this also.

upvoted 1 times

...

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam

Exam 1z0-148 topic 1 question 57 discussion

Comments

Rakeshpro

CosminCof

orakell

Tinamoran

orakell

SY0-701