A. SELEC...

#Questão 101619 - Ciência da Computação, Linguagem SQL, FCC, 2014, Câmara Municipal de São Paulo - SP, Consultor Técnico Legislativo

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’;

Navegue em mais questões

Erro ao Ler: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens