期中考试数据库上机复习提纲.docVIP

实验1 第四章 1.创建数据库 create database sales on primary ( name=sale, filename=c:\data\sale.mdf, size=4, maxsize=10, filegrowth=5%), ( name=sale1, filename=c:\data\sale1.ndf, size=3, maxsize=10, filegrowth=1), filegroup sale_1 ( name=sale2, filename=c:\data\sale_2.ndf, size=3, maxsize=10, filegrowth=1) log on ( name=sale_log, filename=c:\file\sale.ldf, size=3, maxsize=10, filegrowth=1) 2.对数据库的修改 (1)更改数据库名称 alter database sales modify name=newsale (2)向数据库添加文件 alter database newsale add file ( name=sale3, filename=c:\data\sale3.mdf, size=4, m