Exam 1z0-148 topic 1 question 38 discussion

C, not E.

C is correct

C correct

The correct answer is C Because the line "RETURN 99" generate the information compilation

if you execute as command window with the command SHOW ERRORS display PLW-06002: Unreachable code, in SQL Window execute successfully

alter session set plsql_warnings = 'enable:all'; create or replace function compare_numbers(p1 number, p2 number) return number authid current_user is begin if p1 > p2 then return 1; elsif p1 < p2 then return -1; else return 0; end if; return 99; end; Function COMPARE_NUMBERS compilado LINE/COL ERROR --------- ------------------------------------------------------------- 14/5 PLW-06002: Código inaccesible

The correct answer is C, i have a warning generated (PLW-06002: Unreachable code) on line 7 while compiling

A seems right, no warnings generated at all

E also a correct answer since in ENABLE:ALL mode two warnings will be generated. One severe warning and one informational warning.