Kursliste Logg inn

Informasjon

Forfatter(e) Quentin Cappart
Frist Ingen frist
Innleveringsgrense Ingen begrensning

Logg inn

Logg inn

Compréhension des mots clefs (opérations d'ensemble)

Parmi les propositions suivantes, trouvez celle donnant une description correcte des mots-clefs (ou requêtes) suivants.

Spørsmål 1: 
select name
from student
where dept_name = 'Biology'
union
select name
from instructor
where dept_name = 'Biology';
Spørsmål 2: 
select dept_name
from student
union all
select dept_name
from instructor;
Spørsmål 3: 
select dept_name
from student
intersect
select dept_name
from instructor;
Spørsmål 4: 
select course_id
from course
where dept_name = 'Biology'
except
select course_id
from prereq;
Spørsmål 5: 
select ID
from student
intersect
select ID
from instructor;
Spørsmål 6: 
select name, dept_name
from student
union
select name
from instructor;