Database-Management-System

Question 493

Consider the query : SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK5SEM2_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.

Database-Management-SystemSQLUGC NET CS 2008-june-Paper-2

Question 493 Explanation:

Since both the queries are not related so you can solve inner query first and then can solve outer query.

Correct Answer: C

Question 493 Explanation:

Since both the queries are not related so you can solve inner query first and then can solve outer query.