笔试题:
数据库答案:
1、insert student into values(95005,‘王五’,‘男’,23)
2、alter table sc change sdept dept char(6)
3、select sname as ‘姓名’,sage as ‘年龄’ from student
4、desc sc
5、alter table student add index snameindex(sname)
6、uptade sc set grade=
(select grade from sc inner join student on sc.sno=studet.sno where sname='刘晨' and cname='操作系统')
where sname= ‘李勇’ and cname=‘数据库’