ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

42 / 68

Question 42:

See the Exhibit: 
image
The code take a long time to execute. What would you recommend to improve performance? 

Answer options:

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 types instead of the NUMBER data type