{"id":145,"date":"2026-03-21T07:09:09","date_gmt":"2026-03-21T07:09:09","guid":{"rendered":"https:\/\/alpeshconnect.in\/blog\/?p=145"},"modified":"2026-03-21T07:09:09","modified_gmt":"2026-03-21T07:09:09","slug":"student-marksheet-pl-sql-rdbms-practical-exam","status":"publish","type":"post","link":"https:\/\/alpeshconnect.in\/blog\/2026\/03\/21\/student-marksheet-pl-sql-rdbms-practical-exam\/","title":{"rendered":"Student Marksheet – PL\/SQL RDBMS Practical Exam"},"content":{"rendered":"\n

A). Create SQL table with primary key and foreign key with insert 5 records. Stud : ( roll_no,name,gender,mobile) stud_result : ( roll_no,mark1,mark2,mark3,mark4 ) <\/p>\n\n\n\n

B). Pl\/sql block that accept Roll no as input , calculate total marks and percentage of that student. Display student marksheet<\/p>\n\n\n\n

A) Create Tables and Insert Records<\/strong><\/h1>\n\n\n\n

1. Create Stud<\/code> Table (Primary Key)<\/h3>\n\n\n\n
CREATE TABLE Stud (
    roll_no NUMBER PRIMARY KEY,
    name VARCHAR2(50),
    gender VARCHAR2(10),
    mobile VARCHAR2(15)
);<\/pre>\n\n\n\n
\n\n\n\n
2. Create stud_result<\/code> Table (Foreign Key)<\/h3>\n\n\n\n
CREATE TABLE stud_result (
    roll_no NUMBER,
    mark1 NUMBER,
    mark2 NUMBER,
    mark3 NUMBER,
    mark4 NUMBER,
    CONSTRAINT fk_roll FOREIGN KEY (roll_no)
    REFERENCES Stud(roll_no)
);<\/pre>\n\n\n\n
\n\n\n\n
3. Insert Records into Stud<\/code><\/h3>\n\n\n\n
INSERT INTO Stud VALUES (1, 'Amit', 'Male', '9876543210');
INSERT INTO Stud VALUES (2, 'Neha', 'Female', '9123456780');
INSERT INTO Stud VALUES (3, 'Rahul', 'Male', '9988776655');
INSERT INTO Stud VALUES (4, 'Priya', 'Female', '9012345678');
INSERT INTO Stud VALUES (5, 'Karan', 'Male', '9090909090');<\/pre>\n\n\n\n
\n\n\n\n
4. Insert Records into stud_result<\/code><\/h3>\n\n\n\n
INSERT INTO stud_result VALUES (1, 78, 85, 80, 75);
INSERT INTO stud_result VALUES (2, 88, 92, 79, 85);
INSERT INTO stud_result VALUES (3, 67, 70, 72, 68);
INSERT INTO stud_result VALUES (4, 90, 95, 93, 89);
INSERT INTO stud_result VALUES (5, 55, 60, 58, 62);<\/pre>\n\n\n\n
\n\n\n\n
<\/pre>\n\n\n\n
B) PL\/SQL Block (Marksheet Display)<\/strong><\/h1>\n\n\n\n
SET SERVEROUTPUT ON;
DECLARE
    v_roll_no Stud.roll_no%TYPE := &roll_no;    v_name Stud.name%TYPE;
    v_gender Stud.gender%TYPE;    m1 NUMBER;
    m2 NUMBER;
    m3 NUMBER;
    m4 NUMBER;    total NUMBER;
    percentage NUMBER;
BEGIN
    -- Fetch student details
    SELECT name, gender INTO v_name, v_gender
    FROM Stud
    WHERE roll_no = v_roll_no;    -- Fetch marks
    SELECT mark1, mark2, mark3, mark4
    INTO m1, m2, m3, m4
    FROM stud_result
    WHERE roll_no = v_roll_no;    -- Calculate total and percentage
    total := m1 + m2 + m3 + m4;
    percentage := total \/ 4;    -- Display Marksheet
    DBMS_OUTPUT.PUT_LINE('----- STUDENT MARKSHEET -----');
    DBMS_OUTPUT.PUT_LINE('Roll No   : ' || v_roll_no);
    DBMS_OUTPUT.PUT_LINE('Name      : ' || v_name);
    DBMS_OUTPUT.PUT_LINE('Gender    : ' || v_gender);    DBMS_OUTPUT.PUT_LINE('Marks: ');
    DBMS_OUTPUT.PUT_LINE('Mark1     : ' || m1);
    DBMS_OUTPUT.PUT_LINE('Mark2     : ' || m2);
    DBMS_OUTPUT.PUT_LINE('Mark3     : ' || m3);
    DBMS_OUTPUT.PUT_LINE('Mark4     : ' || m4);    DBMS_OUTPUT.PUT_LINE('Total     : ' || total);
    DBMS_OUTPUT.PUT_LINE('Percentage: ' || percentage || '%');EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('Student not found!');
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
END;
\/<\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
A). Create SQL table with primary key and foreign key with insert 5 records. Stud : ( roll_no,name,gender,mobile) stud_result : ( roll_no,mark1,mark2,mark3,mark4 ) B). Pl\/sql block that accept Roll no as input , calculate total marks and percentage of that student. Display student marksheet A) Create Tables and Insert Records 1. Create Stud Table (Primary […]<\/p>\n","protected":false},"author":1,"featured_media":101,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,42],"tags":[25,26,43],"class_list":["post-145","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bca","category-concept-of-rdbms","tag-bca","tag-bca-paper-solution","tag-concept-of-rdbms"],"_links":{"self":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts\/145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/comments?post=145"}],"version-history":[{"count":1,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts\/145\/revisions"}],"predecessor-version":[{"id":146,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts\/145\/revisions\/146"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/media\/101"}],"wp:attachment":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/media?parent=145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/categories?post=145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/tags?post=145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}