1z0-146 Oracle Database 11g: Advanced PL/SQL
Question No. 1
https://drive.google.com/file/d/14e9iqvrByWg7OZdVbspcanuUzA6J_iPL/view?usp=sharingIdentify the sections of the code that need to be modified for better performance gains. (Choose all that apply.)
Choose all the correct options from the given list.
Use cursor to fetch values
Remove redundant SQL statements in the procedures
Avoid the NOT NULL constraint when declaring the variable
Define and compile procedures independently and not as part of a package