删除学生信息表student的所有数据,正确的语句为()
A、delete from student
B、drop table student
C、delete all * from student
D、drop all from student
A、delete from student
B、drop table student
C、delete all * from student
D、drop all from student
A. DROP TABLE dept;
B. DELETE TABLE dept;
C. TRUNCATE TABLE dept;
D. DELETE * . * FROM dept; [END CODE]"
A、DELETE*FROMStudentWHERESno='05019'
B、DELETE*FROMStudentWHERESnoLIKE'019'
C、DELETEFROMStudentWHERESno='05019'
D、DELETEFROMStudentWHERESnoLIKE'019'
A、语句执行时临时产生的表,执行后系统自行会将其删除
B、数据临时表,数据库关闭重启服务即删除
C、语句执行时当前数据库中不存在的表,执行后即新生成该表
D、语句执行时当前数据库中已存在的表,只是向该表追加数据
A、create table tscore (…, score numeric(18,1),… constraint score>=0)
B、create table tscore (…, score numeric(18,1)>=0,… )
C、create table tscore (…, score numeric(18,1),… constraint ck_score check(score>=0))
D、create table tscore (…, score numeric(18,1),… constraint ck_score score>=0)
A、userid;主键
B、userid;唯一
C、uq_userid;外键
D、uq_userid;检查
A、select * from score order by english,maths
B、select * from score order by english asc,maths asc
C、select * from score order by english desc,maths desc
D、select * from score order by maths,english
A、职称='讲师' OR 性别='男'
B、职称='讲师' AND 性别='男'
C、BETWEEN '讲师' AND '男'
D、IN ('讲师', '男')
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!