Which two actions should you perform?

You need to build a table structure for a stored procedure to support data entry from a website form. The website form must meet the following requirements
• Usersmust validate their age as 18 or older to use the website.
• Users who leave the date of birth field blank, or who enter an invalid date, must receive an error message.
Which two actions should you perform? Each correct answer presents part of the solution.
A. Add the CHECK constraint to the table structure.
B. Add the DATEPART function to the stored procedure.
C. Add the DEFAULT constraint to the table structure.
D. Add the SYSDATETIMEOFFSET function to the stored procedure.
E. Add the ISDATE function to the stored procedure.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.