Which of the below PL/SQL programs will execute successfully and retrieve the student name of student with ID as 101?

Option 1

DECLARE
  v_student student%ROWTYPE;
BEGIN
  SELECT student_name INTO v_student FROM student WHERE student_id = 101;
  DBMS_OUTPUT.PUT_LINE('student_name: '|| v_student);
END;

Option 2

DECLARE
  v_student student%ROWTYPE;
BEGIN
  SELECT student_name INTO v_student.student_name FROM student WHERE student_id = 101;
   DBMS_OUTPUT.PUT_LINE('student_name: '|| v_student.student_name);
END;

Option 3

DECLARE
  v_student student%ROWTYPE;
BEGIN
  SELECT * INTO v_student FROM student WHERE student_id = 101;
  DBMS_OUTPUT.PUT_LINE('Student_name:: '|| v_student.student_name);
END;

 

To get all PLSQL Assessment Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee