发布时间 : 星期五 文章《数据库原理及应用》总复习题(带答案)更新完毕开始阅读d2e9228ec1c708a1284a44ed
答案: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