关于美国《独立宣言》，下列说法正确的是（)。A．独立宣言是美洲十三个英属殖民地宣告脱离大不列颠王国

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

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;

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

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;

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

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

A. ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);

B. ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);

C. ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);

D. ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);

E. ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);