View the Exhibit and examine the PL/SQL code. The code takes a long time to execute. What would you recommend to improve performance?

Question

Exhibit

Options

• Ausing NOT NULL constraint when declaring the variables
• Busing the BULK COLLECT option for query instead of cursor
• Cusing WHILE.. END LOOP instead of FOR .. END LOOP
• Dusing the SIMPLE_INTEGER data type instead of the NUMBER data type

• A
  2% (1)
• B
  85% (39)
• C
  4% (2)
• D
  9% (4)

No community discussion yet for this question.