Examine this block:
Which two will be correct after line 5?
A. va. LAST and va. LIMIT will return the same value.
B. va. LAST and va. COUNT will return the same value.
C. va. LIMIT and va. COUNT will return the same value.
D. va. LIMIT and va. NEXT (199) will return the same value.
E. va. LAST will return 200.
F. va. NEXT (199) will return NULL.
B,F
BF
Answer BF
set serveroutput on;
declare
type va$ is varray(200) of number;
va va$ := va$();
begin
va.Extend();
dbms_output.put_line(va.last); — 1
dbms_output.put_line(va.limit); –200
dbms_output.put_line(va.count); — 1
dbms_output.put_line(va.next(199)); –null
end;
/
Correct are B and F.
***** va.EXTEND(100) *****
count: 100
limit: 200
last: 100
next(199):