Which statement is true about the execution of the PL/SQL code?

B

b

the right one is B

create or replace procedure proctest as
stock_price NUMBER := 9.73;
net_earnings NUMBER := 0;
pe_ratio NUMBER;
BEGIN
pe_ratio := stock_price / net_earnings;
DBMS_OUTPUT.PUT_LINE(‘Price/earnings ratio = ‘ || pe_ratio);
END;

Procedure created.

No compilation errors. Only when you call it you got exception for zero divisor.

declare
a number;
b number :=0;
c number;
begin
a := 500;
c := a/b;
end;
/
Error report –
ORA-01476: divisor is equal to zero
ORA-06512: at line 7
01476. 00000 – “divisor is equal to zero”

B

Good article. I certainly like your site. Keep it up!

http://wwwcenturionwealth.com/