You are a database administrator for AIOTestKing.com. You are creating a SQL Server 2005 database that will contain many tables to store contact information for customers, partners, and vendors. You need to ensure consistency in the data types that are used in all columns in the database tables. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
A.
Create a DDL trigger that alerts you when the schema in a table changes.
B.
Create a CHECK constraint to enforce values allowed in the columns in the database tables.
C.
Create CLR user-defined types for use in the tables.
D.
Create a DML trigger that alerts you when the data in a table changes.
E.
Create Transact-SQL user-defined data types for use in the tables.
Explanation:
You should use user-defined data types in the tables. You create the type with either CLR or T-SQL. By using the user-defined data types you specify how data has to be formatted in order to be accepted in the table.