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,


DOWNLOAD & READ Free Dumps For Oracle- 1z0-007



You are reading online questions and answers for Oracle Exam 1z0-007 (Introduction to Oracle9i SQL ) 100% free... Please share this site which will help this community to grow...

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
Description Update Date and Time 2015-12-01 14:45:57

============================================================================

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
Description Update Date and Time 2015-12-01 14:47:08

============================================================================