【单选题】创建员工管理数据库Employ,主要数据文件为Employ,物理文件名为D:\Employ\Employ.mdf,初始大小为3MB,最大容量为20GB,增长速度为10%;事务日志逻辑名称为Employ_log,物理文件名为E:\Employ\Employ_log.ldf,初始大小为1MB,最大容量为600MB,增长速度10%。
A.
CREATE DATABASE Employ ON (NAME=Employ.mdf, FILENAME='D:\ Employ\Employ.mdf', SIZE=3, MAXSIZE=20GB, FILEGROWTH=10%) LOG ON (NAME=Employ_log.ldf, FILENAME='E:\ Employ\Employlog.ldf', SIZE=1, MAXSIZE=600, FILEGROWTH=10%)
B.
CREATE DATABASE Employ ON (NAME=Employ, FILENAME='D:\ Employ\Employ', SIZE=3, MAXSIZE=20GB, FILEGROWTH=10%) LOG ON -- 创建事务日志文件 (NAME=Employ_log, FILENAME='E:\ Employ\Employ_log', SIZE=1, MAXSIZE=600, FILEGROWTH=10%)
C.
CREATE DATABASE Employ ON (NAME=Employ, FILENAME='D:\ Employ\Employ.ldf', SIZE=3, MAXSIZE=20GB, FILEGROWTH=10%) LOG ON -- 创建事务日志文件 (NAME=Employ_log, FILENAME='E:\ Employ\Employ_log.mdf', SIZE=1, MAXSIZE=600, FILEGROWTH=10%)
D.
CREATE DATABASE Employ ON (NAME=Employ, FILENAME='D:\Employ \Employ.mdf', SIZE=3, MAXSIZE=20GB, FILEGROWTH=10%) LOG ON -- 创建事务日志文件 (NAME=Employ_log, FILENAME='E:\ Employ\Employ_log.ldf', SIZE=1, MAXSIZE=600, FILEGROWTH=10%)