You are designing a table to store customer data. The table will contain a column to store the e-mail addresses of the customers. You need to recommend a solution to store the e-mail addresses. The solution must meet the following requirements:

E-mail addresses must contain the @ symbol

E-mail addresses must be validated by using a regular expression

E-mail addresses must contain a top-level domain of .com, .org,

or .edu What should you recommend?

Question

You are designing a table to store customer data. The table will contain a column to store the e-mail addresses of the customers. You need to recommend a solution to store the e-mail addresses. The solution must meet the following requirements:

E-mail addresses must contain the @ symbol
E-mail addresses must be validated by using a regular expression
E-mail addresses must contain a top-level domain of .com, .org,

or .edu What should you recommend?

Accepted Answer

B. Use a CHECK constraint that uses a CLR function.

Answer

A. Create an e-mail profile for the Database Mail SQL Server component.

Answer

C. Add a custom schema to the database.

Answer

D. Use a non-persisted computed column.

You are designing a table to store customer data. The table will contain a column to store the e-mail addresses of the customers. You need to recommend a solution to store the e-mail addresses. The…

Question

Options

How the community answered

Community Discussion