单项选择题

为视图重命名的命令是______。

A．MODIFYVIEW
B．CREATEVIEW
C．DELETEVIEW
D．RENAMEViEW

<上一题目录下一题>

热门试题

单项选择题

检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩的降序排列出来。正确的SELECT语句是______。

A．SELECT S#, SUM(GRAD FROM SC WHERE GRADE＞=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)＞=4
B．SELECT S#, SUM(GRAD FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY 2 DESC
C．SELECT S#, SUM(GRAD FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY 2 DESC
D．SELECT S#, SUM(GRADFROM SC WHERE GRADE＞=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)＞=4

单项选择题

在当前目录下有数据库文件xsdak，数据库中有表文件stu.dbf，执行如下SQL语句 SELECT*FROM student INTO DBF xsdak ORDER BY学号后，______。

A．生成一个按“学号”升序的表文件xsdadbf
B．生成一个按“学号”降序的表文件xsdadbf
C．生成一个新的数据库文件xsdadbc
D．系统提示出错信息

相关试题