Students marks will be stored in Student_marks table. Sample data is given below.

What will be the result after executing below PL/SQL Code?

CREATE OR REPLACE function sf_calc_grade(p_student_id STUDENT_MARKS.STUDENT_ID%type,p_course_id STUDENT_MARKS.COURSE_ID%type)
RETURN varchar2(3)
is
  v_marks student_marks.marks%type;
  v_grade varchar2(3);
BEGIN
  SELECT marks INTO v_marks FROM student_marks WHERE student_id = p_student_id AND COURSE_ID = p_COURSE_ID;
  IF v_marks      >=65 AND v_marks<75 THEN
    v_grade       := 'B';
  elsif v_marks   >=75 AND v_marks <90 THEN
    v_grade       := 'A';
  elsif v_marks   >=90 AND v_marks<=100 THEN
    v_grade       := 'A+';
  ELSE
  v_grade :='C';
  END IF;
  dbms_output.put_line('Course_id: '|| p_course_id ||'Grade:'|| v_grade);
  EXCEPTION
  WHEN OTHERS THEN
  dbms_output.put_line('Some Error Occured');
END;

 

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