网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
根据SQL标准,要删除表student中所有数据,但不将表student的定义一起删除,下面哪个语句可以适用?()
A delete from student
B delete all from student
C delete * from student
D drop table student
参考答案
更多 “ 根据SQL标准,要删除表student中所有数据,但不将表student的定义一起删除,下面哪个语句可以适用?()A delete from studentB delete all from studentC delete * from studentD drop table student ” 相关考题
考题
如果要删除Student数据库中的Information表,可以使用下列哪个命令?一——A.ALTER TABLE InformationB.TRUNCATE TABLE InformationC.DROP。TABLE InformationD.DELETE TABLE Information
考题
根据SQL标准,删除表student中对字段sno的唯一性约束,应该使用下面哪条语句? ()A drop sno from table studentB alter table student drop snoC alter table student drop unique(sno)D alter table student drop sno unique
考题
根据SQL标准,要修改表student中所有学生的年龄age,使之在原值基础上减一,下面哪个语句适用?()A update student set age = 1B update student set age = age - 1C update age = age -1 from studentD update from student where age = age -1
考题
根据SQL标准,要查询表student中所有年龄age小于所有学生的平均年龄的记录,下面哪条语句适用?()A select * from student where ageB select * from student having ageC select * from student a where a.ageD select * from student a where (select avg(b.age) from student b ) >= a.age
考题
要删除Student表的Birthyear列,同时删除所有引用该列的视图和约束。下列哪一个SQL语句正确表达了这一删除要求()。A.ALTERTABLEStudentDELECTBirthyearRESTRICT
B.ALTERTABLEStudentDELETEBirthyearCASCADE
C.ALTERTABLEStudentDROPBirthyearRESTRICT
D.ALTERTABLEStudentDROPBirthyearCASCADE
考题
【填空题】若要删除sutdent表的全部数据,数据删除后不可撤销,应使用语句_______________,若想删除student数据表,应使用语句_____________________。
热门标签
最新试卷