Oracle Database Advanced PL SQL 12c 1z0 148

© examsiri.com

Question : 1 of 54

Marks: +1, -0

The STUDENTS table exists in your schema.
Examine the DECLARE section of a PL/SQL block:

Which two blocks are valid? (Choose two.)

BEGIN OPEN cursor3 FOR SELECT * FROM students; cursor1 :=cursor3; END;
BEGIN OPEN stcur; cursor1 :=stcur; END
BEGIN OPEN cursor1 FOR SELECT * FROM students; stcur :=cursor1; END;
BEGIN OPEN stcur; cursor3 :=stcur; END;
BEGIN OPEN cursor1 FOR SELECT * FROM students; cursor2 :=cursor1; END

Go to Question:

Next Question