Question

Utilize as seguintes estruturas das tabelas a seguir para essa questão:

Nome Nulo? Tipo

----------------------------------------- -------- ----------------------------

EMPLOYEE_ID NOT NULL NUMBER(6)

FIRST_NAME VARCHAR2(20)

LAST_NAME NOT NULL VARCHAR2(25)

EMAIL NOT NULL VARCHAR2(25)

PHONE_NUMBER VARCHAR2(20)

HIRE_DATE NOT NULL DATE

JOB_ID NOT NULL VARCHAR2(10)

SALARY NUMBER(8,2)

COMMISSION_PCT NUMBER(2,2)

MANAGER_ID NUMBER(6)

DEPARTMENT_ID NUMBER(4)



Nome Nulo? Tipo

----------------------------------------- -------- ----------------------------

DEPARTMENT_ID NOT NULL NUMBER(4)

DEPARTMENT_NAME NOT NULL VARCHAR2(30)

MANAGER_ID NUMBER(6)

LOCATION_ID NUMBER(4)



Você deseja recuperar todos os funcionários, que estejam ou não alocados em um departamento, Qual consulta que você usaria?


Escolha uma:
a. SELECT last_name,department_name
FROM employees e RIGHT OUTER JOIN DEPARTMENTS d
ON (e.department_id=d.department_id);

b. SELECT last_name,department_name
FROM employees FULL JOIN DEPARTMENTS
ON (e.department_id=d.department_id); Incorreto

c. SELECT last_name,department_name FROM employees NATURAL JOIN DEPARTMENTS;

d. SELECT last_name,department_name
FROM employees e JOIN DEPARTMENTS d
ON (e.department_id=d.department_id);

e. SELECT last_name,department_name FROM employees JOIN DEPARTMENTS;

f. SELECT last_name,department_name
FROM employees e LEFT OUTER JOIN DEPARTMENTS d
ON (e.department_id=d.department_id);

Answer 1

Resposta:

letra c

Explicação:

espero ter te ajudado