Identify the sections of the code that need to be modified for better performance gains.

View the Exhibit and examine the PL/SQL code.
Identify the sections of the code that need to be modified for better performance gains.
(Choose all that apply.)

A.
Use cursors to fetch values.

B.
Remove redundant SQL statements in the procedures.

C.
Avoid the NOT NULL constraint when declaring the variable.

D.
Define and compile procedures independently, and not as part of a package.