Which statement describes the UTM licensing model？（）

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

ry 21, 20012. Price is less then $500 or greater than $900You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use？ （）

A. SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date ＜ ‘21-JAN-2001‘ ORDER BY purchase_date;

B. SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date ＜ ‘21-JAN-2001‘ ORDER BY purchase date ASC;

C. SELECT book_title FROM books WHERE price ＜ 500 or ＞ 900 AND purchase_date ＜ ‘21-JAN-2001‘ ORDER BY purchase date DESC;

D. SELECT book_title FROM books WHERE (price ＜ 500 OR price ＞ 900) AND purchase_date ＜ ‘21-JAN-2001‘ ORDER BY purchase date DESC;

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

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

A.Identity statement

B.Dream statement

C.Enterprise statement

D.Intelligence statement

E.Positioning Statement

A.Balance Sheet

B.Income Statement

C.Statement of Cash Flow

D.Statement of Retained Earnings