The STUDENT_GRADES table has these columns:
Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?
A. SELECT student_id, gpaFROM student_gradesWHERE semester_end BETWEEN ’01-JAN-2001′ AND ’31-DEC-2001’OR gpa > 3.;
B. SELECT student_id, gpaFROM student_gradesWHERE semester_end BETWEEN ’01-JAN-2001′ AND ’31-DEC-2001’AND gpa gt 3.0;
C. SELECT student_id, gpaFROM student_gradesWHERE semester_end BETWEEN ’01-JAN-2001′ AND ’31-DEC-2001’AND gpa > 3.0;
D. SELECT student_id, gpaFROM student_gradesWHERE semester_end BETWEEN ’01-JAN-2001′ AND ’31-DEC-2001’OR gpa > 3.0;
E. SELECT student_id, gpaFROM student_gradesWHERE semester_end > ’01-JAN-2001′ OR semester_end < ’31-DEC-2001’AND gpa >= 3.0;
|
Download Printable PDF. VALID exam to help you PASS. |
 |