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 7987

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

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

Option B

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

Option C

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

Option D

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

Correct Answer A
Explanation Explanation/Reference: Explanation : ESCAPE identifier to search for the actual % and _ symbol Incorrect answer : B ESCAPE identifier must be use C wrong syntax D wrong syntax Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-13


Question ID 7988

Explanation/Reference: Explanation : ESCAPE identifier to search for the actual % and _ symbol Incorrect answer : B ESCAPE identifier must be use C wrong syntax D wrong syntax Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-13

Option A

SELECT dear customer, customer_name, FROM customer;

Option B

SELECT "Dear Customer", customer_name, ||',' FROM customer;

Option C

SELECT 'Dear Customer' || customer_name ',' FROM customer;

Option D

SELECT 'Dear Customer' || customer_name || ',' FROM customer;

Option E

SELECT "Dear Customer" || customer_name || "," FROM customer; F SELECT 'Dear Customer' || customer_name || ',' FROM customer;

Correct Answer D
Explanation Explanation/Reference: Explanation : Concatenation operator to create a resultant column that is a character expression. Incorrect answer : A no such dear customer column B invalid syntax C invalid syntax E invalid syntax F invalid syntax Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 1-18

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