select * from employees where department_id in (10, 30); select employee_id, first_name, last_name, salary, department_id from employees where depa...
select * from employees where department_id in (10, 30); select employee_id, first_name, last_name, salary, department_id from employees where department_id in (10, 30); select employee_id, first_name, last_name, salary, department_id from employees where department_id in (10, 30) order by last_name; select * from employees where department_id in (10, 30) order by last_name; select employee_id, first_name, last_name, salary, department_id from employees where department_id on (10, 30); Analise o seguinte retorno em uma consulta no usuário HR no banco de dados oracle: Escolha abaixo a alternativa que corresponde com a saída de dados acima:
a) select * from employees where job_id = 'MANAGER' or job = 'SALESMAN';
b) select * from employees where job_id <> 'MANAGER' and job_id <> 'SALESMAN';
c) select * from employees where salary in (800, 1250);
d) select * from employees where salary between 800 and 1250;
a) select * from employees where job_id = 'MANAGER' or job = 'SALESMAN';
b) select * from employees where job_id <> 'MANAGER' and job_id <> 'SALESMAN';
c) select * from employees where salary in (800, 1250);
d) select * from employees where salary between 800 and 1250;
💡 1 Resposta
Ed 
A consulta SQL fornecida retorna os dados dos funcionários cujo department_id é igual a 10 ou 30, ordenados pelo sobrenome. Portanto, a alternativa correta que corresponde à saída de dados acima é: d) select * from employees where salary between 800 and 1250;
Faça como milhares de estudantes: teste grátis o Passei Direto
Esse e outros conteúdos desbloqueados
16 milhões de materiais de várias disciplinas
Impressão de materiais
Agora você pode testar o
Passei Direto grátis
✏️ Responder
Para escrever sua resposta aqui, entre ou crie uma conta
Outros materiais
Perguntas relacionadas
Compartilhar