恒生电子2012实习笔试题

一、不定项选择题

1、B

2、AD

3、CD

4、A

5、ACD

6、BD

7、C

8、BCD

9、C

10、AB 主键不一定能提高查找的速度

二、填空题

1、奇，偶

2、ls -l,ps -aux

3、

4、BABBAB

5、数据定义恒生电子面试题恒生电子面试题，数据操作，数据控制

三、

1、

create table S(

Sno int primary key auto_increment,

Sname varchar(20)

);

insert into S(sname) values('he');

insert into S(sname) values('wang');

create table C(

Cno int primary key auto_increment,

Cname varchar(20),

Ccredit int

);

insert into C(cname,Ccredit) values('JAVA',3);

insert into C(cname,Ccredit) values('C',2);

Drop table if exists SC;

create table SC(

id int primary key auto_increment,

Sno int,

Cno int,

Grade int

);

insert into SC(Sno,cno,Grade) values(1,1,100);

insert into SC(Sno,cno,Grade) values(1,2,90);

insert into SC(Sno,cno,Grade) values(2,1,80);

insert into SC(Sno,cno,Grade) values(2,2,70);

insert into SC(Sno,cno,Grade,Teacher) values(3,1,80,'zhang');

insert into SC(Sno,cno,Grade,Teacher) values(3,2,70,'zhang');

1)select distinct Sname From S,SC,C where S.sno = SC.sno and c.Cno = SC.cno and

Cname='JAVA' order by Sname desc;

select cno from sc a inner join (select * from sc where cno=(selectcno from course where cname='001')) as b on a.cno>o=(select cnofrom course where cname='002')。select res_id,res_name,r_index_id,default_r_i_id,flag from(select top 11 res_id,res_name,r_index_id,default_r_i_id,0 as flag from t_d_resource where res_is_audit=1 and res_run_flat='android' and channel_id=4 and default_r_c_id=163 order by newid() )a union select res_id,res_name,r_index_id,default_r_i_id,1 as flag from t_d_resource where res_id=60892 order by flag desc。select res_id,res_name,r_index_id,default_r_i_id,flag from(select top 11 res_id,res_name,r_index_id,default_r_i_id,0 as flag from t_d_resource where res_is_audit=1 and res_run_flat='android' and channel_id=5 and default_r_c_id=173 order by newid() )a union select res_id,res_name,r_index_id,default_r_i_id,1 as flag from t_d_resource where res_id=83687 order by flag desc。

and Grade>60 group by Sno having sum(Ccredit)>80;

3)ALTER table SC ADD Teacher varchar(20) not null;

4)CREATE VIEW SCSum(sno,Ccredit) as Select S.Sno,Sum(Ccredit) From S,SC,C

where S.sno = SC.sno and c.Cno = SC.cno group by Sno;

5)delete from SC where sno not in(select distinct S.Sno from S);

四、程序设计题

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/ruanjian/article-111966-1.html