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 7993

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?

Option A

SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;

Option B

SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Option C

SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;

Option D

SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;

Option E

SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Correct Answer C
Explanation Explanation : for highest gpa value MAX function is needed, for result with per semester GROUP BY clause is needed Incorrect answer : A per semester condition is not included B result would not display the highest gpa value D invalid syntax error E invalid syntax error Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 5-7


Question ID 7994

In which four clauses can a subquery be used? (Choose four.)

Option A

in the INTO clause of an INSERT statement

Option B

in the FROM clause of a SELECT statement

Option C

in the GROUP BY clause of a SELECT statement

Option D

in the WHERE clause of a SELECT statement

Option E

in the SET clause of an UPDATE statement

Option F

in the VALUES clause of an INSERT statement

Correct Answer ABDE
Explanation Explanation/Reference: Explanation : A: a subquery is valid on the INTO clause of an ISERT Statement B: a subquery can be used in the FROM clause of a SELECT statement D: a subquery can be used in the WHERE clause of a SELECT statement, E: a subquery can be used in the SET clauses of an UPDATE statement, Incorrect answer : C subquery cannot be used F: is incorrect. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 6-5

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