Ciência da Computação Banco de Dados Linguagem SQL

  • A. SELECT DEPTO ASC FROM cadfun ORDER BY NOME DESC;

    ALTER cadfun ADD ADMISSAO DATE;

    SELECT NOME FROM cadfun WHERE month FROM ADMISSAO = 12;
  • B. SELECT * FROM cadfun ORDER BY DEPTO, NOME DESC;

    INSERT INTO cadfun ADMISSAO DATE;

    SELECT NOME, ADMISSAO FROM cadfun WHERE month = 12;
  • C. SELECT DEPTO, NOME FROM cadfun ORDER BY DESC NOME;

    UPDATE TABLE cadfun SET ADMISSAO = DATE;

    SELECT * FROM cadfun WHERE EXTRACT (month FROM ADMISSAO) = ‘12’;
  • D. SELECT DEPTO, NOME FROM cadfun ORDER BY DEPTO, NOME DESC;

    ALTER TABLE cadfun ADD ADMISSAO DATE;

    SELECT NOME, ADMISSAO FROM cadfun WHERE EXTRACT (month FROM ADMISSAO) = 12;
  • E. SELECT DEPTO FROM cadfun ORDER BY NOME DESC;

    UPDATE TABLE cadfun ADD DATE ADMISSAO;

    SELECT NOME, ADMISSAO FROM cadfun WHERE ADMISSAO.month = ‘12’;