Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-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 ?
Which of the following is true ?
|
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.
|
|
|
It gives roll numbers of all students whose marks in semester 1 and semester 2 are same.
|
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.