View the Exhibit and examine the PL/SQL code.
The code takes a long time to execute. What would you recommend to improve performance?
A.
using NOT NULL constraint when declaring the variables
B.
using the BULK COLLECT option for query instead of cursor
C.
using WHILE.. END LOOP instead of FOR .. END LOOP
D.
using the SIMPLE_INTEGER data type instead of the NUMBER data type
D
EDIT: B it is.
answer B) D): “bulk collect into” can improve performance comparing to the manner to iterate cursor. SIMPLE_INTEGER will avoid range validation which will comsume some time so D) is also the answer.
D is the answer, as per Steven Feuerstein CURSOR FOR loops implement the BULK COLLECT INTO strategy since Oracle Database 10g.