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 1653

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 1654

You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE
What happens when you execute this DELETE statement?
 

Option A

A.    You get an error because of a primary key violation.
 

Option B

B.    The data and structure of the EMPLOYEES table are deleted.
 

Option C

C.    You get an error because the statement is not syntactically correct.

 

Option D

D.    The data in the EMPLOYEES table is deleted but not the structure.

Correct Answer D
Explanation

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