问题

The STUDENT_GRADES table has these co

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? （）

A SELECT AVERAGE(gpa) FROM student_grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
B SELECT COUNT(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
C SELECT MIN(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
D SELECT AVG(gpa) FROM student_grades WHERE semester _ end BETWEEN '01-JAN-2000' and '31-DEC-2000';
E SELECT SUM(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
F SELECT MEDIAN(gpa) FROM student_grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000'

参考答案

参考解析：

分类：1Z0-007题库

相关推荐

1、The EMPLOYEE tables has these columns

The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salar...

2、The EMPLOYEE tables has these columns

The EMPLOYEE tables has these columns:You want to display the name and annual salary multiplied by the commission_pct for all employees. For re...

3、The STUDENT_GRADES table has these co

The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)Which statement finds the highest grade point average...

4、The CUSTOMERS table has these columns

The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRESS VARCHAR...

5、The STUDENT_GRADES table has these co

The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The register has requested a report listing the stude...

6、The ORDERS table has these columns:

The ORDERS table has these columns:The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Whic...

编辑推荐

汁用加工柑橘果实中柠碱含量越高越好，因此高柠碱品种亦是加.....

安全检查标准规定（）m以上的高层建筑，应当设置临时消防水源.....

有关直视钳穿法输精管结扎术手术步骤，不正确的是（）..

传阅的公文，在每个部门的停留时间不得超过（）个工作日，每.....

下列不属于幼儿园艺术教育活动的是（）。..

哪项不符合猩红热皮疹的特点（）..