单选题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?（）A SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;B SELECT (gpa) FR

题目
单选题
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?（）
A

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

B

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

C

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

D

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

E

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

相似考题

1.下面有关加入GPA谈判说法正确的是()。A、加入GPA谈判确定了参加方实际受协议管辖的范围B、加入GPA谈判实际遵循的是最惠国待遇原则C、加入GPA谈判实际遵循的是互惠对等原则D、加入GPA谈判的成果主要体现在协议附录二中E、加入GPA谈判可采取“部门对等”和“总量平衡”的方式

2.The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

3.The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

4.加入GPA,有关我国政府采购法律说法正确的是()A.修改和调整以符合GPA规定B.不做修改，直接适用GPAC.对GPA管辖范围，可继续适用采购本国产品条款D.对非GPA管辖范围，禁止适用采购本国产品条款

更多“单选题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?（）A SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;B SELECT (gpa) FR”相关问题

  • 第1题：

    Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?()

    A. MANAGER must be a role.

    B. It allows the MANAGER to pass the specified privileges on to other users.

    C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

    D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

    E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

    F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.


    参考答案：B, E

  • 第2题：

    The STUDENT_GRADES table has these columns: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.

    B.

    C.

    D.

    E.

    F.


    参考答案：D

  • 第3题：

    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';

    正确答案:D

  • 第4题：

    You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）

    • A、CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));
    • B、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
    • C、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));
    • D、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

    正确答案:D

  • 第5题：

    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

    • A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
    • B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
    • C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
    • D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

    正确答案:C

  • 第6题：

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

    • A、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
    • B、SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
    • C、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
    • D、SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
    • E、SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

    正确答案:C

  • 第7题：

    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）

    • A、SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
    • B、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
    • C、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
    • D、SELECT student_id, gpa FROM student_grades ORDER BY gpa;
    • E、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
    • F、SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

    正确答案:F

  • 第8题：

    Which SQL statement returns a numeric value?（）

    • A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
    • B、SELECT ROUND(hire_date) FROM EMP;
    • C、SELECT sysdate-hire_date FROM EMP;
    • D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;

    正确答案:C

  • 第9题：

    单选题
    You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）
    A

    CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));

    B

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

    C

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));

    D

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）
    A

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;

    B

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;

    C

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;

    D

    SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;

    E

    SELECT student_id, semester_end, gpa FROM student_grades


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    The STUDENT_GRADES table has these columns STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?（）
    A

    SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' OR gpa > 3.;

    B

    SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa gt 3.0;

    C

    SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa > 3.0;

    D

    SELECT student_id, gpa FROM student_grades WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >=s 3.0;


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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?（）
    A

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

    B

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

    C

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

    D

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

    E

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


    正确答案： C
    解析： 暂无解析

  • 第13题：

    The STUDENT_GRADES table has these columns:The register has requested a report listing the students‘ grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）

    A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;

    B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC;

    C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;

    D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC;

    E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC;


    参考答案：C

  • 第14题：

    研究生奖学金评定一般按照全部课程成绩GPA计算，全部课程成绩（）为学习成绩。

    • A、GPA×15
    • B、GPA×25
    • C、GPA×35
    • D、GPA×45

    正确答案:B

  • 第15题：

    Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task?（）

    • A、SELECT student_ id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC;
    • B、SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks;
    • C、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC);
    • D、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks DESC) WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id ='INT _ SQL';

    正确答案:D

  • 第16题：

    Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?（）

    • A、An error is returned.
    • B、You are prompted to enter a new value.
    • C、A report is produced that matches the first report produced.
    • D、You are asked whether you want a new value or if you want to run the report based on the previous value.

    正确答案:C

  • 第17题：

    The STUDENT_GRADES table has these columns STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?（）

    • A、SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' OR gpa > 3.;
    • B、SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa gt 3.0;
    • C、SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa > 3.0;
    • D、SELECT student_id, gpa FROM student_grades WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >=s 3.0;

    正确答案:C

  • 第18题：

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

    • A、SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;
    • B、SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
    • C、SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;
    • D、SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;
    • E、SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;

    正确答案:C

  • 第19题：

    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）

    • A、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
    • B、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;
    • C、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;
    • D、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;
    • E、SELECT student_id, semester_end, gpa FROM student_grades

    正确答案:C

  • 第20题：

    单选题
    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';


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）
    A

    SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

    B

    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

    C

    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

    D

    SELECT student_id, gpa FROM student_grades ORDER BY gpa;

    E

    SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

    F

    SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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?（）
    A

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

    B

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

    C

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

    D

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

    E

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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?（）
    A

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

    B

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

    C

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

    D

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

    E

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


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?（）
    A

    An error is returned.

    B

    You are prompted to enter a new value.

    C

    A report is produced that matches the first report produced.

    D

    You are asked whether you want a new value or if you want to run the report based on the previous value.


    正确答案： D
    解析： 暂无解析

相关内容