Questões de Concurso

Considerando as tabelas R e S apresentadas anteriormente, o resultado

Imagem associada para resolução da questão

seria obtido pela execução do comando SQL:

(a)

select * from R

where not exists (select * FROM S where a=c)

(b)

select * from R

where not exists (select * FROM S where a=d)

(c)

select * from S

where not exists (select * FROM R where a=c)

(d)

select * from S

where not exists (select * FROM R where a=d)

(e)

select * from R

where exists (select * FROM S where b=d)