搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

The STUDENT_GRADES table has these columns:<br /> STUDENT_ID NUMBER(12)<br /> SEMESTER_END DATE<br /> GPA NUMBER(4,3)<br /> 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';

查看正确答案
更多“ The STUDENT_GRADES table has these columns:<br /> STUDENT_ID NUMBER(12)<br /> SEMESTER_END DATE<br /> GPA NUMBER(4,3)<br /> 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?（）”相关的问题
第1题
[单选题] 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;  

点击查看答案
第2题
[单选题] 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;  

点击查看答案
第3题
[单选题] 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;  

点击查看答案
第4题
[单选题] You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?（）

A、GRANT select, insert, update ON student_grades TO manager;  B、GRANT select, insert, update ON student_grades TO ROLE manager;  C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;  D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;  E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;  

点击查看答案
第5题
[单选题] You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.Which statement accomplishes this?（）

A、GRANT select, insert, update ON student_grades TO manager  B、GRANT select, insert, update ON student_grades TO ROLE manager  C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;  D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;  E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;  

点击查看答案
第6题
[] You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）

A、A. GRANT select, insert, update ON student_grades TO manager  B、B. GRANT select, insert, update ON student_grades TO ROLE manager  C、C. GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;  D、D. GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;  E、E. GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  F、F.GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;  

点击查看答案
第7题
[单选题] 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));  

点击查看答案
第8题
[单选题] 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));  

点击查看答案
第9题
[多选题] Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH 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.  

点击查看答案
第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  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服