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);

O grupo de comandos SQL que é processado integralmente sem erros, considerando-se a carga inicial das tabelas T1, T2 e T3, é:

Accepted Answer

D) insert into t1 values (9,null);
insert into t2 values (3,5);
insert into t3 values (10,3,40);

Answer

A) insert into t1 values (12,8);
insert into t2 values (3,5);
insert into t3 values (10,3,40);
9

Answer

B) insert into t1 values (9,8);
insert into t2 values (3,5);
insert into t3 values (10,2,40);

Answer

C) insert into t1 values (9,8);
insert into t2 values (3,5);
insert into t3 values (10,6,40);

Answer

E) insert into t1 values (9,NULL);
insert into t2 values (3,5);
insert into t3 values (10,2,40);

Mais questões de SQL