單項(xiàng)選擇題

The STUDENT_GRADES table has these columns:

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   ORDER BY gpa DESC, semester_end ASC;

你可能感興趣的試題

單項(xiàng)選擇題

Which operator can be used with a multiple-row subquery?（）

A. =
B. LIKE
C. BETWEEN
D. NOT IN
E. IS
F. <>

單項(xiàng)選擇題

Examine the structure of the EMPLOYEES table:
Column name Data type Remarks
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
LAST_NAME VARCNAR2(30)
FIRST_NAME VARCNAR2(30)
JOB_ID NUMBER
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER
You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）

A. CREATE INDEX NAME _IDX (first_name, last_name);
B. CREATE INDEX NAME _IDX (first_name, AND last_name)
C. CREATE INDEX NAME_IDX ON (First_name, last_name);
D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

The STUDENT_GRADES table has these columns: 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?（）

你可能感興趣的試題

Which operator can be used with a multiple-row subquery?（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

The STUDENT_GRADES table has these columns:

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?（）