根据SQL标准,删除一个表,应该使用下面哪个语句?()
A DELETE TABLE
B DROP TABLE
C DELETE VIEW
D DROP DATABASE
第1题
根据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
第2题
根据SQL标准,下面哪条语句与select min(age) from student等效?()
A select age from student where age >= min(age)
B select distinct age from student where age >= all min(age)
C select distinct a.age from student a where a.age<= any (select distinctb.age from student b)
D select distinct a.age from student a where a.age<= all (select distinct b.age from student b)
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!