See the Exhibit: 

Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply) 

Answer options:

A. Use cursors to fetch values
B. Remove redundant SQL statements in the procedure
C. Avoid the NOT NULL constraint when declearing the variable
D. Define and compule procedures independently and not as part of a package

BC