"ichor" wrote:

> why is the answer B and E?
> and why isnt it C and E?
>
> 28. (28) You are a database developer for Proseware,Inc. You are creating a
> database named Human Resources for the company. This database will contain
> all employee records and demographics information. The company has 2,000
> employees and experiences a yearly turnover rate of about 2 percent. When
> employees leave the company, all of their records must be retained for
> auditing purposes. Employee demographics information changes at a yearly
> rate of about 9 percent. You do not need to maintain a history of
> demographics changes.
>
>
>
> The scripts that will be used to create the indexes are shown below:
>
>
>
> ALTER TABLE [dbo].[Employee] WITH NOCHECK ADD
>
> CONSTRAINT [pk_Employee] PRIMARY KEY CLUSTERED
>
> ([EmployeeID])
>
> WITH FILLFACTOR = 90
>
> GO
>
> ALTER TABLE [dbo].[EmployeeDemographics] WITH NOCHECK ADD
>
> CONSTRAINT [dbo].[EmployeeDemographics] PRIMARY KEY CLUSTERED
>
> ([EmployeeID])
>
> WITH FILLFACTOR = 90
>
> GO
>
>
>
> You want to conserve disk space and minimize the number of times that
> expansion of the database files needs to occur. All varchar columns are 50
> percent full.
>
>
>
> Which two parameters should you specify for the CREATE DATABASE statement?
> (Each correct answer presents part of the solution. Choose two)
>
> A. SIZE = 1GB
> B. SIZE = 1MB
> C. SIZE= 2048KB
> D. FILEGROWTH = 20
> E. FILEGROWTH = 5%
> F. FILEGROWTH = 0
>
> Ans: B,E
> Testking said C,E
>
>
>
> thanks
> ICHOR
>
>
>