The STUDENT_GRADES table has these columns:

STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA 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



Which two statements about subqueries are true? (Choose two.)

A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
D. A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F. A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.



What are two reasons to create synonyms? (Choose two.)

A. You have too many tables.
B. Your tables are too long.
C. Your tables have difficult names.
D. You want to work on your own tables.
E. You want to use another schema's tables.
F. You have too many columns in your tables.

The STUDENT_GRADES table has these columns: 
STUDENT_ID NUMBER(12) 
SEMESTER_END DATE 
GPA 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?

D. SELECT student_id, semester_end, gpa 
FROM student_grades 
ORDER BY gpa DESC,semester_end DESC; 

Which two statements about subqueries are true? (Choose two.) 

B. A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause. 
C. A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause. 
D. A single row subquery can retrieve data from more than one table. 

What are two reasons to create synonyms? (Choose two.) 

C. Your tables have difficult names. 
E. You want to use another schema's tables.