Thursday 4 January 2018

Oracle 1Z0-148 Question Answer

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


Which two blocks are valid?

A. BEGINOPEN cursor3 FOR SELECT * FROM students;cursor1 :=cursor3;END;
B. BEGINOPEN stcur;cursor1 :=stcur;END;
C. BEGINOPEN cursor1 FOR SELECT * FROM students;stcur :=cursor1;END;
D. BEGINOPEN stcur;cursor3 :=stcur;END;
E. BEGINOPEN cursor1 FOR SELECT * FROM students;cursor2 :=cursor1;END;

Answer: D,E