Consider the query : SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK=SEM2_MARK);Which of the following is true?

It gives roll numbers of all students whose marks in semester 1 and semester 2 are same.

It gives the name of the student whose marks in semester 1 and semester 2 are same.

It gives all the names and roll nos of those students whose marks in semester 1 and semester 2 are same.

It gives the names of all the students whose marks in semester 1 and semester 2 are same.

Consider the query : SELECT student_name FROM student_data WHERE rolln

1.	Consider the query : SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK=SEM2_MARK);Which of the following is true?
A.	It gives the name of the student whose marks in semester 1 and semester 2 are same.
B.	It gives all the names and roll nos of those students whose marks in semester 1 and semester 2 are same.
C.	It gives the names of all the students whose marks in semester 1 and semester 2 are same.
D.	It gives roll numbers of all students whose marks in semester 1 and semester 2 are same.
Answer» D. It gives roll numbers of all students whose marks in semester 1 and semester 2 are same.