What does the following query do?select name, ID, branchfrom student, departmentwhere student.branch = department.branch;

Question

TuteeHUB · Accepted Answer

It gives the values of name, ID, branch from their respective relations where all the values are matching with each other

TuteeHUB · Answer

It gives all values of name, ID, branch from both the relations only if all those attributes are present in both

TuteeHUB · Answer

It gives all values of name, ID, branch from their respective relations

TuteeHUB · Answer

It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same

1.	What does the following query do?select name, ID, branchfrom student, departmentwhere student.branch = department.branch;
A.	It gives all values of name, ID, branch from both the relations only if all those attributes are present in both
B.	It gives all values of name, ID, branch from their respective relations
C.	It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same
D.	It gives the values of name, ID, branch from their respective relations where all the values are matching with each other
Answer» D. It gives the values of name, ID, branch from their respective relations where all the values are matching with each other

Discussion