证券投资的收益包括()。

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;

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;

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;

The STUDENT_GRADES table has these columnsSTUDENT_ID NUMBER(12)SEMESTER_END DATEGPA 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;

alue;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.

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

The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA 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‘;

ademic information.The STUDENTS table stores information about a student. The STUDENT_GRADES table storesinformation 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 thatpoints 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));

ademic 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));

_NAME VARCHAR2(30)COURSE_ID VARCHAR2(10) NOT NULLMARKS NUMBERSTART_DATE DATEFINISH_DATE DATEYou 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 mark 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 mark;

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 mark DESC;

D. 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;

E. 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‘;