以下哪个SQL语句可以完成:在课程表Course中,首先按课程号的降序,然后按课程名的升序建立一个聚集索引CourseIdx?
A.
CREATE CLUSTERED INDEX CourseIdx ON Course(courseNo DESC , courseName)
B.
CREATE INDEX CourseIdx ON Course(courseNo DESC , courseName ASC)
C.
CREATE INDEX CourseIdx ON Course(courseNo, courseName)
D.
CREATE CLUSTERED INDEX CourseIdx ON Course(courseNo, courseName)