What should you do?

You administer a Microsoft SQL Server instance that will support several databases.

You need to ensure that every new database created has a data type named postalcode that contains the

same attributes.

What should you do?
A . Create a user-defined type on the model database.
B . Create a user-defined type on the master database.
C . Create a user-defined data type on the master database.
D . Create a user-defined data type on the model database.

View Answer

Answer: D

Explanation:

One option is to create SQL Server user defined data types. One trick with new databases is to create the objects in the model database, so as new databases are created the user defined data types will automatically be available.

References: https://www.mssqltips.com/sqlservertip/1628/sql-server-user-defined-data-types­rules-and-defaults/