The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, or Microsoft training courses free for a week.
Learn More ❯

Exam 1Z0-146 — Oracle Advanced PL/SQL Developer Certified Professional

Question 2:

1. Explicit cursors
2. Cursor variables
3. Both explicit cursors and cursor variables

A. Can only be used for a single query
B. Is used with the OPEN, FETCH, and CLOSE commands.
C. Can accept parameters
D. Can be passed as a subprogram parameter
E. Can be used in a cursor FOR LOOP.
F. Can make use of SQL attributes (i.e. %FOUND, %NOT_FOUND).

Select the answer that properly matches the above characteristics to explicit cursors, cursor variables, or both:

A. A-3, B-2, C-3, D-1, E-1, F-3
B. A-2, B-3, C-1, D-1, E-1, F-3
C. A-1, B-1, C-2, D-2, E-2, F-1
D. A-1, B-1, C-2, D-2, E-2, F-2
E. A-1, B-3, C-1, D-2, E-1, F-3