根据SQL标准,删除索引应该选用下面哪个语句?()
A DELETE INDEX
B DROP INDEX
C DELETE VIEW
D DROP VIEW
第1题
根据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)
第2题
根据SQL标准,要删除表student中所有数据,但不将表student的定义一起删除,下面哪个语句可以适用?()
A delete from student
B delete all from student
C delete * from student
D drop table student
第4题
根据SQL标准,把表SC1中的记录复制到另一个表SC2中,其中SC1表和SC2表的字段定义完全一样。下面哪条语句适用?()
A copy * from SC1 to SC2
B copy * from SC2 to SC1
C insert into SC2 select * from SC1
D insert into SC1 select * from SC2
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!