2010汕头市业技能大赛助理电子商务师实操题.docVIP

2010汕头市职业技能大赛助理电子商务师实操题 1、 有一个数据库student,数据表computer,字段名为name,number,sex,SQL2000,flash,net ,其中SQL2000,flash,net设置为数值型数据 计算并显示每位同学各科的总分和平均分，并按总分从高到低排序。 (2分) select SQL2000+flash+net as 总分,(SQL2000+flash+net/3) as 平均分;from computer order by SQL2000+flash+net asc select SQL2000+flash+net as 总分,(SQL2000+flash+net+number/4) as 平均分;form computer order by SQL2000+flash+net desc select SQL2000+flash+net as 总分,(SQL2000+flash+net/3) as 平均分;from computer order by SQL2000+flash+net desc select SQL2000+flash+net as 总分,(SQL2000+flash+net+number/4) as 平均分;form computer order by SQL2000+flash+net asc 2、 有一个数据库student,数据表computer,字段名为name,number,sex,SQL2000,flash,net ,其中SQL2000,flash,net设置为数值型数据,删除`平均分最低的3位同学。 (2分) select top 3 *,(SQL2000+flash+net)/3 as 平均分 from computer; order by (SQL2000+flash+net)/3 alter from computer where number in(033001,033003,033011) select top 3 *,(SQL2000+flash+net)/3 as 平均分 from computer; order by (SQL2000+flash+net)/3 delete from computer where number in(033001,033003,033011) select top 3 *,(SQL2000+flash+net)/3 as 平均分 from computer; order by (SQL2000+flash+net)/3 desc alter from computer where number in(033001,033003,033011) select top 3 *,(SQL2000+flash+net)/3 as 平均分 from computer; order by (SQL2000+flash+net)/3 desc update from computer where number in(033001,033003,033011) 3、 输出所有计算机网络成绩在70-79之间的同学，下面正确的是( )? (2分) select all from computer where flash between 70 and 79 select * from computer where flash between 70 and 79 select * from computer where net between 70 and 79 select all from computer where net between 70 and 79 4、 在FrontPage2003中，创建一个框架网页，把浏览器分为左右两个框架，要求左边的框架显示`/exambank/index.asp网页,右边的框架显示`/exambank/main.asp网页，请问下面那个HTML符合要求。 (2分) 〈frameset framespacing=0 border=0 cols=30%,* frameborder=0〉 〈frame name=contents target=main src=/exambank/index.asp〉 〈frame name=main src=/exambank/main.asp〉 〈noframes〉 〈body〉 〈p〉此网页使用了框架，但您的