Question

7

O único conjunto de comandos SQL que pode ter sido usado para instanciar as tabelas R e S é:

Accepted Answer

B) insert into S values (6,1);
insert into S values (4,1);
insert into S values (2,5);
insert into S(d) values (1);
insert into R values (1,2,3);
insert into R(a,b) values (2,3);
insert into R values (5,2,2);
insert into R (a,c) values (6,1);

Answer

A) insert into R values (1,2,3);
insert into R(a,b) values (2,3);
insert into R values (5,2,2);
insert into R (a,c) values (6,1);
insert into S values (6,1);
insert into S values (4,1);
insert into S values (2,5);
insert into S(d,a) values (1,);

Answer

C) insert into R values (1,2,3);
insert into R(a,b) values (2,3);
insert into R values (5,2,2);
insert into R (a,c) values (6,1);
insert into S values (6,1);
insert into S values (4,1);
insert into S values (2,5);
insert into S(d) values (1,,);

Answer

D) insert into R values (1,2,3);
insert into R values (2,3);
insert into R values (5,2,2);
insert into R values (6,1);
insert into S values (6,1);
insert into S values (4,1);
insert into S values (2,5);
insert into S values (1);

Answer

E) insert into R values (1,2,3);
insert into R(a,b) values (2,3,null);
insert into R values (5,2,2);
insert into R (a,c) values (6,null,1);
insert into S values (6,1);
insert into S values (4,1);
insert into S values (2,5);
insert into S(d) values (1,null);

Mais questões de SQL