Tuesday 3 March 2020

Oracle 1Z0-148 Questions Answers

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


Which two blocks are valid?

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

Answer: AE