420
440
450
460
480
第1题:
第2题:
第3题:
第4题:
第5题:
第6题:
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? ()
第7题:
In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?()
第8题:
SELECT AVERAGE(gpa) FROM student_grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
SELECT COUNT(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
SELECT MIN(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
SELECT AVG(gpa) FROM student_grades WHERE semester _ end BETWEEN '01-JAN-2000' and '31-DEC-2000';
SELECT SUM(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
SELECT MEDIAN(gpa) FROM student_grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
第9题:
has grown; has seen
have grown;has seen
have grown;have seen
has grown;have seen
第10题:
200
133
75
67
8
第11题:
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 mark DESC;
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 mark;
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 mark DESC;
SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM <= 10;
SELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';
第12题:
5.3
5
4
6
5.5
第13题:
第14题:
第15题:
第16题:
第17题:
第18题:
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?()
第19题:
You have a computer named Computer1 that runs Windows 7 and Windows Internet Explorer 8. A userreports that Computer1 has a number of Internet Explorer configuration issues that cause instability whenbrowsing the Internet. You need to configure Internet Explorer to use all default settings. What should youdo from Internet Options?()
第20题:
85 percent.
20 percent.
80 percent.
第21题:
SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
SELECT student_id, gpa FROM student_grades ORDER BY gpa;
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
第22题:
Most of the north-eastern institutions were set up for both male and female students.
Most of the north-eastern institutions enrolled only men students or women students before the 1960s.
A lot of institutions in the north-east refused to enroll more students before the 1960s.
Many institutions in the north-east have the same reputation as Harvard or Yale.
第23题:
The Enforce Primary Key property on the STUDENT block is set to Yes.
The Alias property on the COURSES_OFFERED block is set to Student.
The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block.
The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.