What does the following query do?

mhmadesk

Save to bookmark

2022-07-13

469

Medium

What does the following query do?
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

Database, MCQ Questions, Database MCQ-questions,

mhmadesk

2022-07-13

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)