Read online free dumps for Oracle- 1z0-007

Here you can read online questions and answers for Oracle Exam 1z0-007 (Introduction to Oracle9i SQL ) 100% free...

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

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