《数据库原理及应用》总复习题（带答案）

答案：1、

create database test on --建立主数据文件 (

name = test_data, --逻辑文件名

filename='d:\\sql\\test_data.mdf', --size=4mb, --初始大小 maxsize= 10mb, --最大容量 filegrowth = 10% --增长速度 )

log on --建立日志文件 (

name=test_log,

filename='d:\\sql\\test_log.ldf', size=1mb, maxsize = 5mb, filegrowth = 1mb )

2、create table score ( 学号char(8) primary key,

物理文件路径和名字 姓名char(6) not null,

sql float check(sql between 0 and 100), asp float check(asp between 0 and 100), vb float check(asp between 0 and 100)) 3、select * from score

4、select姓名，sql from score order by sql 5、select * from score where 姓名 like ‘王%’ 6、select 学号，姓名,sql+asp+vb as 总分 from score 7、insert into score values（1005，‘赵强’，64，82，69） 8、update score set vb=85 where 姓名=‘王英’

9、create view xs1 as select 学号，姓名，sql from score 10、create procedure pjf @xm char(8)

as select avg(asp+vb+sql) ‘平均分’ from score where姓名=@xm

11、execute pjf

12、create trigger tr1 on score for delete,update,insert as

Print’不允许执行上述操作’ Rollback transaction Return go