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 7875

Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?

Option A

CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);

Option B

CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);

Option C

CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;

Option D

CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

Correct Answer B
Explanation Explanation/Reference: Explanation: This statement will create view that can be used to change tables in underlying table through simple views. It includes primary key, NOT NULL column and foreign key to avoid constraint restrictions. Explanation/Reference: Explanation: This statement will create view that can be used to change tables in underlying table through simple views. It includes primary key, NOT NULL column and foreign key to avoid constraint restrictions.


Question ID 7876

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?

Option A

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?

Option B

SELECT COUNT(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';

Option C

SELECT MIN(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';

Option D

SELECT AVG(gpa) FROM student_grades WHERE semester _ end BETWEEN '01-JAN-2000' and '31-DEC-2000';

Option E

SELECT SUM(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';

Option F

SELECT MEDIAN(gpa) FROM student_grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';

Correct Answer D
Explanation Explanation/Reference: Explanation: Statement in this answer will show correct result, using function AVG(). This function takes the values for a single column on all rows returned by the query and calculates the average value for that column. Incorrect Answers A: There is no AVERAGE() function in Oracle. B: COUNT() will calculate number of row, not an average grade point. C: MIN() function will calculate minimum grade for all students enrolled during semesters that end in the year 2000. E: SUM() will calculate sum of all grade points for all students enrolled during semesters that end in the year 2000. F: There is no MEDIAN() function in Oracle. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 123-125 Chapter 3: Advanced Data Selection in Oracle

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