What Does The Following Query Dobr Select Name Id Branchbr From #589
What does the following query do?<br /> select name, ID, branch<br /> from student, department<br /> where student.branch = department.branch;
This multiple choice question (MCQ) is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Introduction to Relational Model and SQL - Basic Operations - Quiz No.1.
What does the following query do?
select name, ID, branch
from student, department
where student.branch = department.branch;
select name, ID, branch
from student, department
where student.branch = department.branch;
It gives all values of name, ID, branch from both the relations only if all those attributes are present in both
It gives all values of name, ID, branch from their respective relations
It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same
It gives the values of name, ID, branch from their respective relations where all the values are matching with each other
