Pop Quiz (Nov 26, 2005)
Posted by: SQL Server 2005 Distilled,
on 27 Nov 2005 |
View original | Bookmarked: 0 time(s)
What will happen when you run the following command while connected to a SQL Server 2005 instance:
CREATE DATABASE TestDB ON DEFAULT = 10;
a.)Creates a database called TestDB of size 10 MB with user data by default on primary filegroup.
b.)Creates a database called TestDB of size 10 MB with data and log files on default database location on disk
c.)Generates a syntax error
d.)Creates a database called TestDB with default size, ignoring the specified value (10)
Click for answer:...