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 8009

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 to create an equi-join?

Option A

SELECT last_name, department_name, location_id FROM employees , department ;

Option 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

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

Option 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 Explanation/Reference: Exp Equijoins are also called simple joins or inner joins. Equijoin involve primary key and foreign key. Incorrect answer : A there is no join B invalid syntax C does not involve the join in the primary and foreign key Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 4-8lanation :


Question ID 8010

The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement?

Option A

The results are not sorted.

Option B

The results are sorted numerically

Option C

The results are sorted alphabetically.

Option D

The results are sorted numerically and then alphabetically.

Correct Answer D
Explanation Explanation/Reference: Explanation : the result is sort by price which is numeric and follow by product_name which is alphabetically. Incorrect answer : A the results are sorted B the results are sorted with alphabetically as well C the results are sorted with numerically as well Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-2

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