Questões da Prova FCC - 2018 - DPE-AM - Analista em Gestão Especializado de Defensoria - Analista de Banco de Dados

PROCEDURE P1 IS

SELECT A, B

FROM T;

INSERT PROCEDURE P1 INTO DATABASE AS

SELECT A, B

FROM T

CREATE PROCEDURE P1( )

SELECT A, B

FROM T;

MAKE PROCEDURE P1 (SELECT A, B

FROM T);

PROCEDURE P1 AS

SELECT A, B

FROM T

UPDATE Disciplinas SET Taxa = 750.00

WHERE Local = ‘interno’

MODIFY Disciplinas MAKE Taxa = 750.00

FOR Local =’ interno’

CHANGE Disciplinas SET Taxa = 750.00

FOR Local =’ interno’

MODIFY Disciplinas MAKE Taxa = 750.00

WHERE Local =’ interno’

UPDATE Disciplinas DO Taxa = 750.00

FOR Local =’ interno’

SELECT Fabricante, MED (Valor)

FROM Vendas

WHERE MED (Valor) > 100.00

SELECT Fabricante, AVG (Valor)

FROM Vendas

GROUP BY Valor

WHERE AVG (Valor) > 100.00

SELECT Fabricante, MED (Valor)

FROM Vendas

GROUPING Fabricante WITH AVG (Valor) > 100.00

SELECT Fabricante, AVG (Valor)

FROM Vendas

GROUP BY Fabricante

HAVING AVG (Valor) > 100.00

SELECT Fabricante, AVG (Valor)

FROM Vendas

JOIN Fabricante AND AVG (Valor) > 100.00