数据库zj练习题.docVIP

数据库练习题： p65、 1、（1）create database webshop2 on (name=webshop2_dat,filename=f:\data\webshop2_dat.mdf, size=5mb,filegrowth=1mb) log on (name=webshop2_log,filename=f:\data\webshop2_log.ldf, size=2mb,filegrowth=10) （3）1、use webshop2 alter database webshop2 add log file (name=webshop2_log1,filename=f:\data\webshop2_log1.ldf) 2、alter database webshop2 modify file (name=webshop2_dat,maxsize=500mb) 3、alter database webshop2 modify file (name=webshop2_log,maxsize=300mb) --教材P107课堂实践1 1、SELECT * FROM Customers 2、SELECT c_ID 用户名,c_Name 真实姓名,c_TrueName 真实姓名,c_Password 密码 FROM Customers