O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

CONSULTAS SQL

Paco Fontanero 10 perguntas Atualizado em 10 mai 2018

Fazer o quiz

Perguntas do quiz (10)

  1. 1Obtener los códigos de las partes fabricadas en una ciudad en la que vive al menos un suministrador y en cual se monta al menos un proyecto.
    1. AImagem da opção A
    2. BImagem da opção B
    3. CImagem da opção C
    4. DImagem da opção D
  2. 2Obtener los códigos de los suministradores que solo venden partes no usadas por el proyecto 'J1'.
    1. AImagem da opção A
    2. BImagem da opção B
    3. CImagem da opção C
    4. DImagem da opção D
  3. 3Obtener los códigos de los proyectos que solo usan partes no vendidas por el suministrador 's1'.
    1. ASELECT DISTINCT jn
      FROM spj
      WHERE jn NOT IN
      (SELECT jn FROM spj WHERE pn IN
      (SELECT pn FROM spj WHERE sn = 's1'
      )
      );
    2. BSELECT DISTINCT jn
      FROM spj x
      WHERE NOT EXISTS
      (SELECT *
      FROM spj
      WHERE jn = x.jn
      AND pn IN
      (SELECT pn FROM spj WHERE sn = 's1'
      )
      );
    3. CSELECT jn
      FROM j
      WHERE jn NOT IN
      (SELECT jn FROM spj WHERE pn IN
      (SELECT pn FROM spj WHERE sn = 's1'
      )
      );
    4. DSELECT DISTINCT jn
      FROM spj
      WHERE jn NOT IN
      (SELECT jn FROM spj WHERE pn NOT IN
      (SELECT pn FROM spj WHERE sn = 's1'
      )
      );
  4. 4¿Cuáles son las ciudades en las que vive más de un suministrador?
    1. ASELECT DISTINCT ciudad FROM s, s x WHERE s.ciudad = x.ciudad AND s.sn < x.sn;
    2. BSELECT DISTINCT s.ciudad
      FROM s,
      s x
      WHERE s.ciudad = x.ciudad
      AND s.sn <> x.sn;
    3. CSELECT DISTINCT ciudad
      FROM s x
      WHERE ciudad IN
      (SELECT ciudad FROM s WHERE sn <> x.sn
      );
    4. DSELECT DISTINCT s.ciudad FROM s, s x WHERE s.ciudad = x.ciudad AND s.sn < x.sn;
  5. 5Obtener los códigos de los proyectos que usan todas las partes que no han sido vendidas por el suministrador 'S1'
    1. ASELECT jn
      FROM j
      WHERE NOT EXISTS
      (SELECT pn
      FROM p
      WHERE NOT EXISTS
      (SELECT * FROM spj WHERE pn = p.pn AND sn='s1'
      )
      AND NOT EXISTS
      ( SELECT * FROM spj WHERE jn = j.jn AND pn=p.pn
      )
      );
    2. BSELECT jn
      FROM j
      WHERE NOT EXISTS
      (SELECT pn
      FROM spj x
      WHERE pn not in
      (SELECT pn FROM spj WHERE sn = 's1')
      AND NOT EXISTS
      ( SELECT * FROM spj WHERE jn = j.jn AND pn=x.pn
      )
      );
    3. CSELECT jn
      FROM j
      WHERE NOT EXISTS
      (SELECT pn
      FROM p
      WHERE pn not in
      (SELECT pn FROM spj WHERE sn = 's1')
      AND NOT EXISTS
      ( SELECT * FROM spj WHERE jn = j.jn AND pn=p.pn
      )
      );
  6. 6Obtener los códigos de las partes no usadas en el proyecto 'J1'
    1. ASELECT pn FROM p
      MINUS
      SELECT pn FROM spj WHERE jn = 'j1';
    2. BSELECT pn
      FROM p
      WHERE NOT EXISTS
      (SELECT * FROM spj WHERE pn = p.pn AND jn='j1'
      );
    3. CSELECT pn
      FROM p
      WHERE NOT EXISTS
      (SELECT * FROM spj WHERE pn <> p.pn AND jn='j1'
      );
    4. DSELECT pn FROM p WHERE pn NOT IN
      (SELECT pn FROM spj WHERE jn = 'j1'
      );
  7. 7Obtener los nombres de los proveedores que vendan al menos una parte roja que haya sido usada por algún proyecto de Telde.
    1. ASELECT DISTINCT snombre
      FROM s
      WHERE sn IN
      (SELECT sn
      FROM spj x
      WHERE EXISTS
      (SELECT *
      FROM spj y
      WHERE pn =x.pn
      AND 'Telde' =
      (SELECT ciudad FROM j WHERE jn=y.jn
      )
      AND 'rojo' IN
      (SELECT color FROM p WHERE pn=y.pn
      )
      )
      );
    2. BSELECT DISTINCT snombre
      FROM s
      WHERE sn IN
      (SELECT sn
      FROM spj
      WHERE pn IN
      (SELECT pn
      FROM spj
      WHERE jn IN
      (SELECT jn FROM j WHERE ciudad='Telde'
      )
      AND pn IN
      (SELECT pn FROM p WHERE color='rojo'
      )
      )
      );
    3. CSELECT DISTINCT snombre
      FROM s
      WHERE sn IN
      (SELECT sn
      FROM spj x
      WHERE EXISTS
      (SELECT *
      FROM spj
      WHERE pn =x.pn
      AND 'Telde' =
      (SELECT ciudad FROM j WHERE jn=x.jn
      )
      AND 'rojo' IN
      (SELECT color FROM p WHERE pn=x.pn
      )
      )
      );
    4. DSELECT DISTINCT snombre
      FROM s,
      spj,
      spj x,
      p,
      j
      WHERE s.sn=spj.sn
      AND spj.pn=x.pn
      AND x.jn =j.jn
      AND x.pn =p.pn
      AND ciudad='Telde';
  8. 8Obtener los códigos de los suministradores que venden cada parte roja a cada proyecto de Telde.
    1. ASELECT sn
      FROM s a
      WHERE NOT EXISTS
      (SELECT pn
      FROM p b
      WHERE color='rojo'
      AND NOT EXISTS
      (SELECT sn,
      pn
      FROM s x,
      p y
      WHERE NOT EXISTS
      (SELECT jn
      FROM j
      WHERE ciudad='Telde'
      AND NOT EXISTS
      (SELECT * FROM spj WHERE sn=x.sn AND pn=y.pn AND jn=j.jn
      )
      )
      AND sn=a.sn
      AND pn=b.pn
      )
      );
    2. BSELECT sn
      FROM s
      WHERE NOT EXISTS
      (SELECT pn,
      jn
      FROM p,
      j
      WHERE color ='rojo'
      AND j.ciudad='telde'
      AND NOT EXISTS
      (SELECT * FROM spj WHERE sn=s.sn AND pn=p.pn AND jn=j.jn
      )
      );
    3. CSELECT sn
      FROM s
      WHERE NOT EXISTS
      (SELECT pn
      FROM p x
      WHERE NOT EXISTS
      (SELECT jn
      FROM j
      WHERE ciudad = 'Telde'
      AND NOT EXISTS
      (SELECT *
      FROM spj,
      p
      WHERE spj.pn=p.pn
      AND color ='rojo'
      AND p.pn =x.pn
      AND jn =j.jn
      )
      )
      AND NOT EXISTS
      (SELECT * FROM spj WHERE pn=x.pn AND sn=s.sn
      )
      );
  9. 9Obtener los códigos de los proyectos que no usan la parte 'P1'
    1. ASELECT jn FROM j WHERE jn NOT IN
      (SELECT jn FROM spj WHERE pn='p1'
      );
    2. BSELECT jn FROM j
      MINUS
      SELECT jn FROM spj WHERE pn='p1';
    3. CSELECT jn FROM j WHERE NOT EXISTS
      (SELECT * FROM spj WHERE jn=j.jn AND pn='p1'
      );
    4. DSELECT jn
      FROM j
      WHERE NOT EXISTS
      (SELECT * FROM spj WHERE jn<>j.jn AND pn='p1'
      );
  10. 10Obtener código de los proyectos montados en una ciudad en la que vive al menos un suministrador y se fabrica al menos una parte.
    1. ASELECT JN
      FROM j
      WHERE EXISTS
      (SELECT * FROM s,p WHERE s.ciudad=j.ciudad AND p.ciudad=j.ciudad
      );
    2. BSELECT DISTINCT jn FROM j,s,p WHERE j.ciudad=s.ciudad AND j.ciudad=p.ciudad;
    3. CSELECT jn
      FROM j
      WHERE EXISTS
      (SELECT * FROM s WHERE ciudad=j.ciudad
      )
      AND EXISTS
      (SELECT * FROM p WHERE ciudad=j.ciudad
      );
    4. DSELECT jn
      FROM j
      WHERE EXISTS
      (SELECT * FROM s,p WHERE s.ciudad=p.ciudad AND p.ciudad=j.ciudad
      );

Informações

Descrição
Quiz sobre CONSULTAS SQL, criado por Paco Fontanero em 08-05-2018.
Idioma
Español
Visualizações
20
Histórico
Criado em 8 mai 2018 · atualizado em 10 mai 2018
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?