oracle练习题_tablespace livebos pctfree 10 initrans 2 maxtrans -CSDN博客

本文链接：https://blog.csdn.net/dxdxdx11/article/details/108124483

本文主要探讨了Oracle数据库的相关练习题，涵盖了SQL查询、数据库管理、性能优化等多个方面，旨在提升对Oracle数据库的实际操作能力。

摘要由CSDN通过智能技术生成

create table CLASSINFO
(
  CLASSID     NUMBER not null,
  CLASSNUMBER VARCHAR2(20) not null,
  CTEACHERID  NUMBER not null,
  CLASSGRADE  VARCHAR2(2) not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table CLASSINFO
  add constraint PK_CLASSID primary key (CLASSID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table CLASSINFO
  add constraint CK_CLASSGRADE
  check (ClassGrade in('S1','S2','Y2'));

create table STUDENTEXAM
(
  EXAMID      NUMBER not null,
  EXAMNUMBER  VARCHAR2(32) not null,
  ESTUID      NUMBER not null,
  EXAMSUBJECT VARCHAR2(20) not null,
  EXAMRESULT  NUMBER
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table STUDENTEXAM
  add constraint PK_EXAMID primary key (EXAMID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table STUDENTEXAM
  add constraint CK_EXAMRESULT
  check (EXAMRESULT>=0 and EXAMRESULT<=100);


create table STUDENTINFO
(
  STUID       NUMBER not null,
  STUNUMBER   VARCHAR2(10) not null,
  STUNAME     VARCHAR2(32) not null,
  STUAGE      NUMBER,
  STUSEX      VARCHAR2(3) default '男' not null,
  STUCARD     VARCHAR2(20),
  STUJOINTIME DATE not null,
  STUADDRESS  VARCHAR2(50),
  SCLASSID    NUMBER
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table TEACHERINFO
(
  TEACHERID    NUMBER not null,
  TEACHERNAME  VARCHAR2(20) not null,
  TEACHERTEL   VARCHAR2(20),
  TEACHEREMAIL VARCHAR2(20)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table TEACHERINFO
  add