• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Question -

What can be used to ensure that a field in a table only accepts a certain range of values?



Answer -

This question can be answered a couple of different ways, but only one answer is a "good" one. The answer you want to hear is a Check constraint, which is defined on a database table that limits the values entered into that column. These constraints are relatively easy to create, and they are the recommended type for enforcing domain integrity in SQL Server. Triggers can also be used to restrict the values accepted in a field in a database table, but this solution requires the trigger to be defined on the table, which can hinder performance in certain situations. For this reason, Microsoft recommends Check constraints over all other methods for restricting domain integrity.

Comment(S)

Show all Coment

Leave a Comment


Selected

 

Computer Contributors

Aquarian Infotech System
Devraj Nagar
krishan
Rajeev Katiyar
Rashmi
Sandeep Saxena
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners