81数据查询语宫中SELECTFORM、WHERE、O RDER BY、GROUPBY、HAVING的执行顺序是0。
A. FROM->WHERE->GROUP BY->HAVING>SELECT->ORDER BY
B. SELECT->FROM->WHERE->GROUP BY->HAVING->ORDER BY
C. .SELECT->FROM->WHERE->GROUP BY->ORDER BY->HAVING
D. FROM->SELECT->WHERE->GROUP BY->HAVING->ORDER BY
查看答案
82下列语句中可以修改表test名称为test1的是()。
A. alter table test rename to test1;
B. rename test to test1;
C. alter table test set name= test1;
D. alter table test change to test1
83下列函数中可以实现逻辑判断的是哪个?
A. CASE WHEN
B. DateTrunc
C. SUM
D. COUNT
84在创建数据库时数据库名称最长可以()字符。
A. 64
B. 128
C. 256
D. 1024
85以下语句中可以实现将成绩表score学号为18137221508学生的课程号为c08106的平时成绩da ily修改为80分的是?
A. update score set daily=80 where studen tno='18137221508’or courseno=c08106’
B. update score set daily=80 where studen tno='18137221508’ and courseno='c08106
C. update score set daily=80 where studen tno=18137221508’;
D. update score daily=80 where studentno='18137221508' and courseno=c08106;
微信支付 
支付宝支付