Question

Considere um banco de dados no qual tenham sido executados os seguintes comandos SQL:

drop table t3;
drop table t1;
drop table t2;

create table t1 ( A int primary key, E int );

create table t2 ( B int primary key, D int not null );

create table t3 ( X int not null, Y int not null, Z int, constraint fk31 foreign key (X) references T1, constraint fk32 foreign key (Y) references T2, constraint uk31 unique(Y) );

insert into t1 values (10,8);
insert into t1 values (11,9);
insert into t1 values (12,5);

insert into t2 values (2,5);
insert into t2 values (4,8);
insert into t2 values (5,6);

insert into t3 values (10,2,20);
insert into t3 values (10,4,null);
insert into t3 values (12,5,30);

A consulta SQL que não produz como resultado 10 2 20 12 5 30 é:

Accepted Answer

E) select * from t3 where x >= 10

Answer

A) select * from t3 where x >= 10 and z >= 0

Answer

B) select * from t3 where x >= 10 and z <= 30

Answer

C) select * from t3 where x >= 10 and (z =0 or z <> 0)

Answer

D) select * from t3 where (z >= 20 or z <= 30)

Mais questões de SQL – consultas, junções e agregação