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 1766

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?
 

Option A

A.    SELECT employee_id, last_name, job_id FROM employees
WHERE job_id = '%SA_';
 

Option B

B.    SELECT employee_id, last_name, job_id FROM employees
WHERE job_id LIKE '%SA_';
 

Option C

C.    SELECT employee_id, last_name, job_id FROM employees
WHERE job_id LIKE '%SA_' ESCAPE "\";
 

Option D

D.    SELECT employee_id, last_name, job_id FROM employees
WHERE job_id LIKE '%SA\_%' ESCAPE '\';
 

Correct Answer D
Explanation


Question ID 7836

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

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