EPS Alunos1

Prévia do material em texto

21/11/2017 BDQ Prova
http://simulado.estacio.br/alunos/ 1/3
RODRIGO SANTOS DE CARVALHO
201506179584 GILBERTO GIL
Voltar 
 
 IMPLEMENTAÇÃO DE BANCO DE DADOS
Simulado: CCT0083_SM_201506179584 V.1 
Aluno(a): RODRIGO SANTOS DE CARVALHO Matrícula: 201506179584
Desempenho: 0,5 de 0,5 Data: 16/11/2017 10:22:55 (Finalizada)
 
 1a Questão (Ref.: 201506790112) Pontos: 0,1 / 0,1
Sabendo-se que existem dados de TCC cadastrados com datas de defesa que variam de 20/11/2012 até a
data de hoje, assinale qual das alternativas abaixo retornaria o mesmo resultado que o comando "SELECT *
FROM TCC WHERE DTDEFESA BETWEEN '15/11/2014' AND '16/11/2014';":
SELECT * FROM TCC WHERE DTDEFESA => '15/11/2014' AND <= '16/11/2014';
SELECT * FROM TCC WHERE DTDEFESA = '15/11/2014' AND '16/11/2014';
SELECT * FROM TCC WHERE DTDEFESA > '15/11/2014' AND < '16/11/2014';
SELECT * FROM TCC WHERE DTDEFESA IN ('15/11/2014' AND '16/11/2014');
 SELECT * FROM TCC WHERE DTDEFESA IN ('15/11/2014','16/11/2014');
 
 2a Questão (Ref.: 201506780829) Pontos: 0,1 / 0,1
A constraint Foreign Key possui no SQL Ansi quais regras?
On Delete Set Null / On Delete Restrict / On Update Set Null / On Update Delete
On Delete Set Null / On Delete Set Default / On Update Set Null / On Update Set Default
On Delete Cascade / On Delete Set Null / On Update Cascade / On Update Set Null
 On Delete Cascade / On Delete Restrict / On Update Cascade / On Update Delete
On Delete Cascade / On Delete Restrict / On Delete Set Null / On Update Cascade / On Update Delete / On
Update Set Null
 
 3a Questão (Ref.: 201506460552) Pontos: 0,1 / 0,1
Qual a ordem correta dos argumentos DQL-SELECT:
 SELECT - FROM - JOIN - WHERE - GROUP BY - HAVING - ORDER BY
SELECT - FROM - JOIN - WHERE - HAVING - GROUP BY - ORDER BY
SELECT - FROM - JOIN - WHERE - GROUP BY - ORDER BY - HAVING
21/11/2017 BDQ Prova
http://simulado.estacio.br/alunos/ 2/3
SELECT - FROM - WHERE - JOIN - HAVING - GROUP BY - ORDER BY
SELECT - FROM - WHERE - JOIN - GROUP BY - HAVING - ORDER BY
 
 4a Questão (Ref.: 201506787345) Pontos: 0,1 / 0,1
 
SELECT DISTINCT NOMEP FROM PROFESSOR P , TCC T, ALUNO A;
SELECT NOMEP FROM PROFESSOR P , TCC T, ALUNO A WHERE P.MATP = A.MATP AND A.MATA = T.MATA;
SELECT NOMEP "Nome do Professor" FROM PROFESSOR P , TCC T, ALUNO A WHERE P.MATP = A.MATP AND
A.MATA = T.MATA;
SELECT DISTINCT NOMEP "Nome do Professor" FROM PROFESSOR P , TCC T, ALUNO A;
 SELECT DISTINCT NOMEP "Nome do Professor" FROM PROFESSOR P , TCC T, ALUNO A WHERE P.MATP =
A.MATP AND A.MATA = T.MATA;
 Gabarito Comentado.
 
 5a Questão (Ref.: 201506460542) Pontos: 0,1 / 0,1
Para se obter a quantidade de empregados por cargo deve-se digitar qual o select abaixo:
SELECT C.DESCRICAO AS CARGO, COUNT(E.MATRICULA) AS QTDE FROM CARGO C INNER JOIN
EMPREGADO E GROUP BY C.DESCRICAO;
SELECT C.DESCRICAO AS CARGO, COUNT(E.MATRICULA) AS QTDE GROUP BY C.DESCRICAO FROM CARGO
C INNER JOIN EMPREGADO E ON C.CODIGO = E.CARGO;
SELECT C.DESCRICAO AS CARGO, SUM(E.MATRICULA) AS QTDE FROM CARGO C INNER JOIN EMPREGADO
E ON C.CODIGO = E.CARGO GROUP BY C.DESCRICAO;
 SELECT C.DESCRICAO AS CARGO, COUNT(E.MATRICULA) AS QTDE FROM CARGO C INNER JOIN
EMPREGADO E ON C.CODIGO = E.CARGO GROUP BY C.DESCRICAO;
SELECT DESCRICAO AS CARGO, COUNT(MATRICULA) AS QTDE FROM CARGO C INNER JOIN EMPREGADO E
ON CODIGO = CARGO GROUP BY DESCRICAO;
 Gabarito Comentado.
 
 
21/11/2017 BDQ Prova
http://simulado.estacio.br/alunos/ 3/3