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- 1z1-051





Question ID 4920

What is true of using group functions on columns that contain NULL values?
 

Option A

A.    Group functions on columns ignore NULL values.
 

Option B

B.    Group functions on columns returning dates include NULL values.
 

Option C

C.    Group functions on columns returning numbers include NULL values.
 

Option D

D.    Group functions on columns cannot be accurately used on columns that contain NULL values.
 

Option E

E.    Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
 

Correct Answer A
Explanation


Question ID 4921

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

A.    SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
 

Option B

B.    SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
 

Option C

C.    SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
 

Option D

D.    SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
 

Option E

E.    SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
 

Correct Answer C
Explanation

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