oracle考试参考资料.docxVIP

---Exp1 create tablespace ts_130202021038 datafile C:\oracledata\orcl11g\ts_130202021038001.dbf size 10M reuse autoextend on next 64K maxsize 50M; alter tablespace ts_130202021038 add datafile C:\oracledata\orcl11g\ts_130202021038002.dbf size 10M reuse autoextend on next 64K maxsize 50M; alter database datafile C:\oracledata\orcl11g\ts_130202021038002.dbf offline drop; ---Exp2 create table business( bno char(10) primary key, bname char(50) not null, btype char(4) check(btype in (企业, 事业, 私有)), badderss char(20), btel char(13) )tablespace ts_130202021038; select * from business; desc business; create table hospital( hno char(5) primary key, hname char(40) not null, haddress char(60) )tablespace ts_130202021038; select * from hospital; desc hospital; create table card( cno char(15) primary key, ctype char(8) check (ctype in (企业, 事业, 灵活就业)), cmoney number(7, 2) not null )tablespace ts_130202021038; select * from card; desc card; create table staff( sno char(5) primary key, sname char(20) not null, ssex char(2) check (ssex in (男,女)), sbirthday date, saddress char(20), stel char(15) unique, cno char(15) , bno char(10) , constraint staff_card foreign key (cno) references card(cno), constraint staff_business foreign key (bno) references business(bno) )tablespace ts_130202021038; select * from staff; desc staff; create table see( sno char(5) , hno char(5), sdate date, primary key(sno, hno, sdate), constraint staff_see foreign key(sno) references staff(sno) on delete cascade, constraint staff_hospital foreign key(hno) references hospital (hno) )tablespace ts_130202021038; select * from see; desc see; create table consume( cno char(15) , hno char(5), csdate date not null, mname char(20), mnum int not null, csmoney number(7,2) not null, primary key (cno, hno, csdate), constraint cno_consume foreign key(cno) references card(cno) on delete cascade, constraint consume_hospital foreign key(hno) references hos