Consider the following table students: Figure from the original question paper Which of the following SQL queries will return the names of students who are 20 years old and have grade 'A'?

(A) SELECT name FROM students WHERE age = 20 AND grade = 'A';

(C) SELECT name FROM students WHERE students.age = 20 AND grade = 'A';

(B) SELECT FROM students WHERE age = 20 OR grade = 'A';

(D) SELECT name FROM students WHERE student.grade = 'A' OR student.age = 20;

Modern Application Development I · Quiz 2 · 23 Nov 2025 · September 2025 term

Question 16: Consider the following table students: Which of the foll…

Question 16

+2 marksOne or more correct options

Consider the following table students:

Which of the following SQL queries will return the names of students who are 20 years old and have grade 'A'?

Select all that apply.

A
SELECT name FROM students WHERE age = 20 AND grade = 'A';
B
SELECT * FROM students WHERE age = 20 OR grade = 'A';
C
SELECT name FROM students WHERE students.age = 20 AND grade = 'A';
D
SELECT name FROM students WHERE student.grade = 'A' OR student.age = 20;

Show answer

Correct answers

A
SELECT name FROM students WHERE age = 20 AND grade = 'A';
C
SELECT name FROM students WHERE students.age = 20 AND grade = 'A';

See the whole paper Take it as a mock test

Question 16 of 16 in the IIT Madras BS Modern Application Development I (MAD 1) Quiz 2 paper sat on 23 Nov 2025, in the September 2025 term (IIT M DIPLOMA AN EXAM QDD2 23 Nov 2025 NEW). It carries 2 marks.

Question 16: Consider the following table students: Which of the foll…

Question 16

More questions from this paper