Questões de Concurso Público TCE-AM 2021 para Auditor Técnico de Controle Externo - Tecnologia da Informação - 2ª dia

create table E1 (A1 int not null, B1 int,

constraint PK1 primary key(A1))

create table E2 (A2 int not null, A1 int not null, B2 int,

constraint PK2 primary key(A2),

constraint FK foreign key(A1) references E1(A1))

create table E1 (A1 int not null, B1 int,

constraint PK1 primary key(A1) ,

constraint FK foreign key(A1) references E2(A1))

create table E2 (A2 int not null, A1 int not null, B2 int,

constraint PK2 primary key(A2, A1))

create table E1 (A1 int not null, B1 int,

constraint PK1 primary key(A1))

create table E2 (A2 int not null, A1 int not null, B2 int,

constraint PK2 primary key(A2),

constraint FK foreign key(A1) references E1(B1))

create table E1 (A1 int not null, B1 int,

constraint PK1 primary key(A1))

create table E2 (A2 int not null, A1 int not null, B2 int,

constraint PK2 primary key(A2, A1),

constraint FK foreign key(A1) references E1(A1))

create table E1 (A1 int not null, B1 int,

   constraint PK1 primary key(A1) ,

   constraint FK foreign key(A1) references E2(A1))

create table E2 (A2 int not null, A1 int not null, B2 int,

   constraint PK2 primary key(A2, A1),

   constraint FK foreign key(A1) references E1(A1))