The STRING_TAB table has the following structure:
View the Exhibit and examine the code.
What is the outcome on execution?
A.
It displays
Output buffer not long enough.
This is my test string.-.
B.
It displays only
Output buffer not long enough, and exits the anonymous block.
C.
It displays only
This is my test string. – Because EXCEPTION should have been defined in the anonymous block
to get the error message.
D.
It does not display any of the MEMS_PUTPUT messages and gives an error because a
transaction control statement cannot be used in the exception section of aprocedure.
A
A
a
A
A
set SERVEROUTPUT ON;
/
declare
in_string varchar2(25) := ‘this is my test string.’;
out_string varchar2(25);
procedure double (original in varchar2, new_string out varchar2) is
begin
new_string := original || ‘+’ || original;
exception
when value_error then
dbms_output.put_line(‘output buffer not long enough.’);
commit;
end;
begin
double (in_string, out_string);
dbms_output.put_line(in_string || ‘-‘|| out_string);
end;
/
can someone explain this to me please
A
A
Hi! Can someone send me please the latest dumps please? In the real exam there is only about 15 of these question. I went through this like 10 times, learned all the explanations, but got 56% (needed 65%). Please, someone help? My email – [email protected]
All the dumps that are for sale have the same questions in them as here.
Reply