databases Online Quiz - 91
Description: databases Online Quiz - 91 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
The Student_Grades table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date. Which statement will accomplish 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, gpa ASC order by semester_end DESC, gpa DESC; C. SELECT Student_id, semester_end, gpa from student_grades order by semester_end DESC, gpa ASC; D. SELECT Student_id, semester_end, gpa from student_grades order by semester_end ASC, gpa ASC; E. SELECT Student_id, semester_end, gpa from student_grades order by semester_end DESC, gpa ASC;
Which are the two ways of retrieving the execution plan for an SQL statement?
Which of these are types of table partitioning?
Which are the 4 ways of partitioning an existing table?
What is the command to get information about the currently running processes in SQL Server?
What is the command to view/change SQL Server level paramaters/properties?
Which of the following SQL service is dependent of SQL Server service?
What are the 3 recovery models in SQL Server?
On what default port does SQL Server run?
What component of SQL Server is used to send emails in SQL Server 2005?