stuinfo table.txt

在线考试系统设计

create table stuinfo(
sno number(4),
sname char(8) not null,
spass char(6) not null,
sex   char(2),
sclass char(20),
mscore number(4),
escore number(4),
constraint pk_stuinfo primary key(sno)
);
insert into stuinfo values(1001,'褚廷军','ctj','男','计算七班',null,null);
insert into stuinfo values(1002,'张三','002','男','计算七班',null,null);

//


create table exam(
eid char(4) not null,
tcontent varchar(100)not null,
toption  varchar(100),
type    varchar(10),
tkey    char(3),
constraint pk_exam primary key(tcontent)
);

insert into exam values('e','(1).Take an umbrella with you in case_____.','A) it will rain B) it rains C) it raining D) it rained','b');

insert into exam values('e','(2).He is no longer the honest man___he was.','A) who B) whom C) which D) that','b');
insert into exam values('e','(3).During the recession,thousands of workers were____.','A) laid on B) laid down C) laid out D) lain off','c');
insert into exam values('m','(1).25+2*_____=75 ?','A) 10 B) 20 C) 15 D) 25','d');
insert into exam values('m','(2).2+2*_____=12 ?','A) 10 B) 13 C) 15 D) 12','d');