数据库相关习题答案.docVIP

1．create database cpxs on ( name=cpxs_data, filename=d:\cpxs\cpxs_data.mdf, size=3MB, maxsize=10MB, filegrowth=10% ) log on ( name=cpxs_log, filename=d:\cpxs\cpxs_log.ldf, size=1MB, maxsize=5MB, filegrowth=200KB ) 2．alter database cpxs modify file (name=cpxs_data, maxsize=30MB, filegrowth=10% ) Go 3. alter database cpxs add file (name=cpxs_data1, filename=d:\cpxs\cpxs_data1.mdf, size=2MB, maxsize=20MB, filegrowth=10%) go 4. create database cpxs_snapshot on (name=cpxs_date1, filename=d:\cpxs\cpxs_data1.mdf ), (name=cpxs_date, filename=d:\cpxs\cpxs_data.ndf ) as snapshot of cpse_data1 alter database cpxs remove file cpxs_data1 go restore database cpxs from database_snapshot=cpxs_snapshot 1. create table xs ( 借书证号char(8) not null primary key, 姓名char(8) not null, 专业名char(12) not null, 性别char(2) default1not null, 出生时间datetime not null, 借书量int not null, 照片image ) alter table xs add 逾期未还书数tinyint alter table xs drop column 逾期未还书数 alter table xs alter column 姓名char(10) alter table xs alter column 出生时间smalldatetime 2. create table jy ( 借书证号char(8) not null, isbn char(16) not null, 索书号char(10) not null, 借书时间datetime not null, primary key(借书证号,isbn)) 3. create table book ( isbn char(16) not null primary key, 书名varchar(26) not null, 作者char(8) not null, 出版社char(20) not null, 价格float(8) not null, 复本量int not null, 库存量int not null) 4. create table course ( courseID nchar(6) not null primary key, courseName nvarchar(30) not null, precourseID nchar(6), credit tinyint, coursetime nvarchar(30), stulimited tinyint default250, stupreSelect tinyint default0) 5. create table dept ( deptID char(4) not null primary key, deptName varchar(30) not null, phone varchar(12)) alter table dept add 院系地址varchar(50) alter table dept drop column 院系地址 6. create table grade ( stuID char not null, courseID nchar not null, grade decimal, primary key(stuID,courseID) 7. create table stu ( stuID char(12) not null primary key, stuName varchar(10) not null, stuSex char(2) default男, stuBirth datetime , stuP