AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 1678

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:
EMPLOYEES EMPLOYEE
_    ID NUMBER

DEPARTMENT_ ID NUMBER MANAGER_ID NUMBER
LAST_NAME VARCHAR2(25)
DEPARTMENTS DEPARTMENT_    ID NUMBER

MANAGER_ID NUMBER
DEPARTMENT_NAME VARCHAR2(35)
LOCATION_ID NUMBER
You want to create a report displaying employee last names, department names, and locations. Which query should you use?
 

Option A

A.    SELECT last_name, department_name, location_id FROM employees , departments ;
 

Option B

B.    SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D
WHERE e.department_id =d.department_id;

 

Option C

C.    SELECT e.last_name, d.department_name, d.location_id

FROM employees e, departments D WHERE manager_id =manager_id;
 

Option D

D.    SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D
WHERE e.department_id =d.department_id;
 

Correct Answer D
Explanation


Question ID 1679

The EMP table contains these columns:
LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2)
DEPARTMENT_ID NUMBER (6)
You need to display the employees who have not been assigned to any department. You write the SELECT statement:
SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP
WHERE DEPARTMENT_ID = NULL;
What is true about this SQL statement ?
 

Option A

A.    The column in the WHERE clause should be changed to display the desired results.
 

Option B

B.    The operator in the WHERE clause should be changed to display the desired results.
 

Option C

C.    The WHERE clause should be changed to use an outer join to display the desired results.

 

Option D

D.    The SQL statement displays the desired results.

Correct Answer B
Explanation

Send email to admin@getfreedumps for new dumps request!!!