Figure from the original question paper

(A) WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id GROUP BY s.student_id, s.student_name ) SELECT FROM AvgMarks WHERE avg_marks > 60

(B) CREATE VIEW AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id WHERE m.marks > 60 GROUP BY s.student_id ) SELECT FROM AvgMarks

(C) WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id ) SELECT FROM AvgMarks WHERE avg_marks > 60

(D) SELECT student_id, student_name, AVG(marks) FROM Student NATURAL JOIN Marks WHERE AVG(marks) > 60

Database Management Systems · Quiz 1 · 15 Mar 2026 · January 2026 term

DBMS Quiz 1 15 Mar 2026 — Question 6

Question 6

+4 marksOne correct option

A
WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id GROUP BY s.student_id, s.student_name ) SELECT * FROM AvgMarks WHERE avg_marks > 60
B
CREATE VIEW AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id WHERE m.marks > 60 GROUP BY s.student_id ) SELECT * FROM AvgMarks
C
WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id ) SELECT * FROM AvgMarks WHERE avg_marks > 60
D
SELECT student_id, student_name, AVG(marks) FROM Student NATURAL JOIN Marks WHERE AVG(marks) > 60

Show answer

Correct answer

A
WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id GROUP BY s.student_id, s.student_name ) SELECT * FROM AvgMarks WHERE avg_marks > 60

See the whole paper Take it as a mock test

Question 6 of 16 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 15 Mar 2026, in the January 2026 term (Database Management Systems 15 Mar 26). It carries 4 marks.

DBMS Quiz 1 15 Mar 2026 — Question 6

Question 6

More questions from this paper