check, not null,unique

Answers were Sorted based on User's Feedback



check, not null,unique..

Answer / prasanthi

Check Constraint:

The CHECK constraint is used to limit the value range that
can be placed in a column.

not null constraint:

if we give not null constraint to any column it will not
accept null values.

Unique Conatraint:

Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.

Is This Answer Correct ?    5 Yes 0 No

check, not null,unique..

Answer / chaitu

These are contraints

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is the system function to get the current user's user id?

3 Answers   TCS,


What are the source of constraints?

0 Answers  


How can I know what locks are running on which resource?

0 Answers  


What are exact numeric data types in ms sql server?

0 Answers  


Tell me what is difference between view and materialized view?

0 Answers  






Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  


What is db stored procedure?

0 Answers  


How many types of triggers in sql server?

0 Answers  


What is a collation?

0 Answers  


What stored procedure would you use to view lock information?

0 Answers  


How to rebuild indexes with alter index ... Rebuild?

0 Answers  


What are indexes in ms sql server?

0 Answers  


Categories