The STUDENT_GRADES table has these columns:The register has requested a report listing the

A. The set of statements contains an error and does not work.

B. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

C. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

D. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.

E. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.

F. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

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

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.

A. The set of statements contains an error and does not work.

B. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

C. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

D. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.

E. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.

F. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

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

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

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