DELETE FOR年龄>30
DELETE FROM student WHERE年龄>30
DELETE student FOR年龄>30
DELETE student WHERE年龄>30
第1题:
删除视图STUDENT的命令是( )。
A.DELETE STUDENT VIEW
B.DELETE STUDETN
C.DROP STUDENT VIEW
D.DROP VIEW STUDENT
第2题:
根据SQL标准,下面哪句语句能够找出年龄最小的同学?其中age为学生表student中的年龄字段,sno为学生的学号。()
A select max(age) from student
B select sno from student where age = max(age)
C select sno from student having age = max(age)
D select sno from student a where a.age<= (select min(b.age) from student b)
第3题:
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令是( )。
A.DELETE FOR AGE>30
B.DELETE FROM S WHERE AGE>30
C.DELETE S FOR AGE>30
D.DELETE S WHERE AGE>30
第4题:
删除视图STUDENT的命令是( )。
A.DELETE STUDENTVIEW
B.DELETE STUDETN
C.DROP STUDENTVIEW
D.DROPVIEW STUDENT
第5题:
根据SQL标准,要查询表student中所有年龄age小于所有学生的平均年龄的记录,下面哪条语句适用?()
A select * from student where age< avg(age)
B select * from student having age< avg(age)
C select * from student a where a.age< (select avg(b.age) from student b)
D select * from student a where (select avg(b.age) from student b ) >= a.age
第6题:
从student表删除年龄大于30的记录的正确SQL命令是( )。
A.DELETE FOR年龄>30
B.DELETE FROM student WHERE年龄>30
C.DELETE student FOR年龄>30
D.DELETE student WHERE年龄>30
第7题:
根据SQL标准,要删除表student中所有数据,但不将表student的定义一起删除,下面哪个语句可以适用?()
A delete from student
B delete all from student
C delete * from student
D drop table student
第8题:
在Visual FoxPro中,如果要将学生表S(学号,姓名,性别,年龄)中“年龄”属性删除,正确的SQL命令是______。
A.ALTER TABLE S DROP COLUMN 年龄
B.DELETE 年龄 FROM S
C.ALTER TABLE S DELETE COLUMN 年龄
D.ALTER TABLE S DELETE 年龄
第9题:
SQL 语句 DELETE FROM 学生 WHERE 年龄>25的功能是( )。
A.删除学生表
B.删除学生表中的年龄字段
C.将学生表中年龄大于25的记录逻辑删除
D.将学生表中年龄大于25的记录物理删除
第10题:
用SQL语句将STUDENT表中字段“年龄”的值加1,可以使用的命令是
A)UPDATE STUDENT SET年龄=年龄+1
B) UDDATE STUDENT年龄WITH年龄+1
C)REPLACE STUDENT年龄=年龄+1
D)REPLACE STUDENT年龄WITH年龄+1