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 7967

Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?

Option A

SELECT * FROM emp_dept_vu;

Option B

SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;

Option C

SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;

Option D

SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000

Option E

None of the statements produce an error; all are valid.

Correct Answer E
Explanation Explanation/Reference: Explanation : None of the statements produce an error. Incorrect answer : A Statement will not cause error B Statement will not cause error C Statement will not cause error D Statement will not cause error


Question ID 7968

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? DELETE employees;

Option A

You get an error because of a primary key violation

Option B

The data and structure of the EMPLOYEES table are deleted.

Option C

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

Option D

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

Correct Answer C
Explanation Explanation : You can remove existing rows from a table by using the DELETE statement. DELETE [FROM] table [WHERE condition]; Incorrect answer : A Statement will not cause error B Delete statement will not delete the table structure D Statement will not cause error Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 8-19

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