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 7837

Examine the data in the EMPLOYEES and DEPARTMENTS tables.

EMPLOYEES

LAST_NAME DEPARTMENT_ID SALARY

Getz 10 3000

Davis 20 1500

Bill 20 2200

Davis 30 5000

Kochhar 5000

DEPARTMENTS

DEPARTMENT_ID DEPARTMENT_NAME

10 Sales

20 Marketing

30 Accounts

40 Administration

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

Option A

SELECT last_name, department_name FROM employees , departments(+);

Option B

SELECT last_name, department_name FROM employees JOIN departments(+);

Option C

SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d

Option D

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

Option E

SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);

Option F

SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);

Correct Answer F
Explanation Explanation/Reference: Explanation: Answer F is correct. This query shows correct syntax to retrieve all employees, whether or not they have matching departments in the department table. Oracle9i extends its compliance with ANSI/ISO by supporting that standard's requirements for outer join syntax and semantics. Incorrect Answers A: This query uses "+" to create outer join as it was in Oracle8i, but it requires also usage of WHERE clause in SELECT statement. B: The JOIN clause cannot be used with in conjunction with "+": syntax is incorrect. C: The JOIN clause cannot be used with in conjunction with "+": syntax is incorrect. D: This statement requires LEFT OUTER JOIN, not RIGHT OUTER JOIN. E: This query uses incorrect syntax with "+" and ON to create outer join. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 112-114 Chapter 3: Advanced Data Selection in Oracle


Question ID 7839

Examine the structure of the EMPLOYEES table:

EMPLOYEE_ID NUMBER Primary Key

FIRST_NAME VARCHAR2(25)

LAST_NAME VARCHAR2(25)

Which three statements inserts a row into the table? (Choose three)

Option A

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

Option B

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

Option C

INSERT INTO employees VALUES ('1000','JOHN','NULL');

Option D

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

Option E

INSERT INTO employees (employee_id) VALUES (1000);

Option F

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

Correct Answer CEF
Explanation Explanation/Reference: Explanation: Since EMPLOYEE_ID column is used as primary key, it cannot be NULL, so only INSERT statements in C, E and F are correct. You can insert the row with NULL LAST_NAME as in answer C, or only the row with EMPLOYEE_ID as in answer E, or the row with empty LAST_NAME column. Incorrect Answers A: This answer is incorrect because a primary key cannot be NULL. B: INSERT statement does not contain primary key value at all, so this answer needs to be eliminated as correct one. D: This statement shows incorrect order of columns of row which needs to be inserted into the table. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 260-267 Chapter 6: Manipulating Oracle Data

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