ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

27 / 68

Question 27:

Which two statements are true about cursor variables? (Choose two.) 

Answer options:

A. Cursor variables can be parameterized like cursors
B. The query associated with a cursor variable cannot reference host varaible and PL/SQL variables
C. The FETCH statemetn executes the query assocaited with a cursor variable and identifies the result yet
D. Cursor attributes (%FOUND,%NOTFOUND,%ISOPEN and %ROWCOUNT) can be applied to a cursor variable
E. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set