Questões de Concurso Público GHC-RS 2023 para Analista de Sistemas

DROP TABLE DISCIPLINA;

DROP TABLE PROFESSOR;

DROP TABLE TURMA;

DROP TABLE PROFESSOR;

DROP TABLE DISCIPLINA;

DROP TABLE TURMA;

DROP TABLE TURMA;

DROP TABLE DISCIPLINA;

DROP TABLE PROFESSOR;

DROP TABLE PROFESSOR;

DROP TABLE TURMA;

DROP TABLE DISCIPLINA;

DROP TABLE DISCIPLINA;

DROP TABLE TURMA;

DROP TABLE PROFESSOR;

DROP TURNO_PREFERENCIAL

ON TABLE PROFESSOR;

DELETE COLUMN TURNO_PREFERENCIAL

FROM PROFESSOR;

DELETE ON PROFESSOR

COLUMN TURNO_PREFERENCIAL;

ALTER PROFESSOR

DELETE TURNO_PREFERENCIAL;

ALTER TABLE PROFESSOR

DROP COLUMN TURNO_PREFERENCIAL;

SELECT T.ID, D.NOME, P.NOME, T.TURNO

FROM TURMA T, DISCIPLINA D, PROFESSOR P

WHERE D.ID = T.ID_DISCIPLINA

AND P.ID = T.ID_PROFESSOR;

SELECT TURMA.*, DISCIPLINA.NOME, PROFESSOR.NOME

FROM TURMA, DISCIPLINA, PROFESSOR

WHERE TURMA.ID = DISCIPLINA.ID_DISCIPLINA

AND TURMA.ID = PROFESSOR.ID_PROFESSOR;

SELECT ID, DISCIPLINA.NOME, PROFESSOR.NOME, TURNO

FROM TURMA, DISCIPLINA, PROFESSOR

WHERE ID = ID_DISCIPLINA

AND ID = ID_PROFESSOR; 

SELECT *

FROM TURMA T WHERE (SELECT NOME FROM DISCIPLINA

WHERE ID = T.ID_DISCIPLINA) > 0

AND (SELECT NOME FROM PROFESSOR WHERE ID = P.ID_DISCIPLINA) > 0

SELECT T.ID, D.NOME_DISCIPLINA, P.NOME_PROFESSOR, T.TURNO

FROM TURMA T, DISCIPLINA D, PROFESSOR P

WHERE T.ID_DISCIPLINA IN D.ID

AND T.ID_PROFESSOR IN P.ID;