Questão 59 · Tribunal de Contas da União — Auditor Federal de Controle Externo – Área Controle Externo 2022 (FGV)

Question

Supondo que a coluna sequencia da tabela T, anteriormente definida, deveria conter números inteiros em sequência contínua, seria preciso descobrir os intervalos de valores faltantes. Um valor é considerado faltante quando a) é um número inteiro n entre o menor e o maior valor da tabela, tal que n não esteja presente na tabela, ou b) é um número presente na tabela T, com valor nulo na coluna caracteristica. inicio fim faltantes 3 3 1 5 5 1 7 9 3 11 11 1 O comando SQL que produz o resultado acima, a partir da instância inicialmente definida para a tabela T, é:

Accepted Answer

B) select t1.sequencia +1 'inicio', t2.sequencia -1 'fim', t2.sequencia - t1.sequencia -1 faltantes from T t1, T t2 where t1.sequencia < t2.sequencia and t1.sequencia <> t2.sequencia -1 and t1.caracteristica is not null and t2.caracteristica is not null and (not exists (select * from T t3 where t3.sequencia > t1.sequencia and t3.sequencia < t2.sequencia and t3.caracteristica is not null))

Answer

A) select t1.sequencia 'inicio', t2.sequencia 'fim', t2.sequencia - t1.sequencia -1 faltantes from T t1, T t2 where t1.sequencia < t2.sequencia and t1.sequencia <> t2.sequencia -1 and not exists (select * from T t3 where t3.sequencia > t1.sequencia and t3.sequencia < t2.sequencia)

Answer

C) select t1.sequencia +1 'inicio', t2.sequencia -1 'fim', t2.sequencia - t1.sequencia -1 faltantes from T t1, T t2 where t1.sequencia <> t2.sequencia -1 and t1.caracteristica is not null and t2.caracteristica is not null and (not exists (select * from T t3 where t3.sequencia > t1.sequencia and t3.sequencia < t2.sequencia and t3.caracteristica is not null) or exists (select * from T t3 where t3.sequencia > t1.sequencia and t3.sequencia < t2.sequencia and t3.caracteristica is null))

Answer

D) select t1.sequencia +1 'inicio', t2.sequencia -1 'fim', t2.sequencia - t1.sequencia -1 faltantes from T t1, T t2 where t1.sequencia < t2.sequencia and t1.sequencia <> t2.sequencia -1 and t1.caracteristica is not null and t2.caracteristica is not null and exists (select * from T t3 where t3.sequencia > t1.sequencia and t3.sequencia < t2.sequencia)

Answer

E) select t1.sequencia +1 'inicio', t2.sequencia -1 'fim', t2.sequencia - t1.sequencia -1 faltantes from T t1, T t2 where t1.sequencia < t2.sequencia and t1.sequencia <> t2.sequencia -1 and t1.caracteristica is not null and t2.caracteristica is not null and not exists (select * from T t3 where t3.sequencia > t1.sequencia and t3.sequencia < t2.sequencia)

FGV, Tribunal de Contas da União

Questões parecidas