What should you create?

Correct Answer for the following Question is given below

You are designing a database that will store telephone numbers. You need to ensure that only phone numbers that use a specific format are written to the database.What should you create?CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical (Boolean) expression that returns TRUE or FALSE based on the logical operators. For example, the range of values for a PhoneNumber column can be limited by creating a CHECK constraint that allows for only phone numbers with the following format: xxx-xxx-xxxx.ALTER TABLE Table1ADD CONSTRAINT ChkPhoneNumber CHECK (PhoneNumber Like ‘[0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]’);GO

Question:

What should you create?

Options:

a CHECK constraint

a computed column

a DEFAULT constraint

a persisted computed column

Correct Answer

The Correct Answer for this Question is

a CHECK constraint

Explanation

The Question – What should you create? has been answered correctly and answers for the question is a CHECK constraint

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified