单项选择题

在SQL中，CREATE VIEW语句用于建立视图。如果要求对视图更新时，必须满足子查询中的条件表达式，应当在该语句中使用短语( )。

A．WITH UPDATE
B．WITH INSERT
C．WITH DELETE
D．WITH CHECK OPTION

<上一题目录下一题>

热门试题

单项选择题

假设某数据库表中有一个“工作时间”字段，查找20天之内参加工作的记录的准则是( )。

A．BETWEEN Date()OR Date()－20
B．＜Date()AND＞Date()－20
C．BETWEEN Date()AND Date()－20
D．＜Date()－20

单项选择题

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

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

GROUP BY S#
ORDER BY 2 DESC
D．SELECT S#，SUM(GRADE) FROM SC
WHERE GRADE＞=60
ORDER BY2 DESC
GROUP BY S#
HAVING COUNT(*)＞=4

相关试题